Coordinate data between two workbooks

[ECSMark]

I have two workbooks. The first consists of 3 pages. Page 1 is the list of computers in the school. Page 2 is the list of printers. Page 3 is the list of projectors, scanners and cameras. All pages are sorted by room number.
The second workbook has a menu page with all room numbers listed and there are 60 more pages, one for each room. I have it set up so when I select a room number that page comes up. I would like to get the list of computers, printers, etc. from the master list automatically brought into the second workbook and placed in the correct room.The data columns in the second workbook are in the same order as the columns in the master list.
When I change information in the master list I want it to also change the information in the correct room.

As a bonus I would like to go into a room and if I have to change the information of an item it will update the master llist

• Edit

 

[Tuelor]

Access maybe better suited for this one, as it would be easier to enforce relationship between the stored data.

 

[ECSMark]

Thanks for the reply but I would have no idea how to do this in Access. It took several days to figure out how to make the second workbook.