Building Info ( Excel Expert Urgent)

I have 32 workbooks one for each product we have in one file. These are identical workbooks in size/field numbers/layout. I want to create a simple query document/worksheet that simply has one enquiry field which points to the appropiate worksheet of the product i want to search and then auto fills the other query fields in the query document. I am sure this is an easy task involving index, indirect and match functions and some management grouping of the worksheets... Once I have been given the methodology I think I will be fine in propogating it in the master file