Counting materials used on site

Hi All,

I wonder if any one can help me out with this?

I have a master workbook called "BoM count" which I would like to have capture all the materials used on site. This info has already been captured on the workbook "Survey of materials used on site" (There are losts of these, 1 per site)

I want to open the survey within the BoM count workbook and pull out the relivant numbers of materials used and also list the site ID to show that, that survey has been completed

Many Thanks

Mods/Admin - I have started this thread again in another sub forum, can you please close this one for me? I wasnt sure how close a thread? Apologies if I have broken a rule here