Macro to get data from multiple sheets in one workbook into a second workbook

[ECSMark]

I have two workbooks. One is the master inventory list consisting of five sheets. The second is an inventory summary consisting of menu sheet and a sheet for each room. When I click the room number the correct room sheet comes up. I cannot figure out a Macro or formula that will bring the correct data from the master list into the correct room. I have to use two workbooks because the master list is used by the school district and I cannot modify the format. The summary workbook is so I can see what is in each room. I only need from the master workbook columns A - G from the sheets named "Computers", "Printers" and Projectors, Scanners" transferred to the summary woorkbook. Any help anyone can give me? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Sektor]

Please, post examples of these two workbooks.

 

[ECSMark]

FAQ says I cannot attach workbooks to my question. How can I show you a sample? I can attach them to an e-mail to you if you want me to do that. Then you can reply in the forum. Thanks.

 

[Sektor]

I've sent you private message.

 

[Sektor]

I have solved your problem, but you should test it. Please, send me your ICQ in private message to discuss it further.

 

[Sektor]

Download and try.