Hi, could someone please help me

I am a Network Administrator with medium knowledge base of excel.

What I am trying to do is create a an excel database that keeps a list of all our servers, IP, OS, software (easy enough)
But the tricky bit (to me anyway) is

I will have multiple sheets with in this workbook on of the sheets will be a master sheet holding all the data the other sheets will adopt parent child relation ship - if I make changes on the master sheet it will make changes on all the other sheets with in the workbook

I have tried creating macros for the task controlled by shortcut keys - but this seems impractical as I have run out of letters to assign for macro short cuts...
Any help would be greatly appreciated

Some more info....

Basically as mention above the master sheet will contain the following fields,
Server Name/Make/OS/IPaddress/SoftwareInstalled/location/ServiceTAG/contractStart/contracEnd.
***This will be the master sheet basically holding all the data***

Now I wish to create more sheets within the workbook one sheet will have all the support details for each server

The second will a have a list of all the web servers and registered FQDNS

the third will have a list of all applications and functions, basically all the child sheets will pull data from the master sheet which I will update as necessary - and the data will be applied across all the child sheets with in the workbook.
The child sheets will be for viewing purposes only not editing

Just out of interest, why are you trying to build a database using a spreadsheet? Why not use a database. Or even Access. You'll find things much easier, honest .

Chris

There are two secrets to success in this world:
1. Never tell everything you know