Search multiple worksheets and copy cells to summary sheet

Hi,

I have multiple worksheets that I need to use data from to create a summary sheet. We have various job types at my work, each one having it's own job costing sheet within the same workbook. There are 4 different job costing sheets for each month so I will, at year end, have 48 sheets that will need to be searched. I need to create a summary sheet in which I can enter the sales order number in column B and have excel search the job costing sheets and copy the margin % cell for each job with the matching sales order number (which is column B on each sheet) onto the summary sheet.

I hope my question makes sense. I greatly appreciate any help anyone can provide, I am an excel novice and haven't been able to find an answer to this by searching the forums. I am using Excel 2003.

Thank you,

Jill

Hi Jill,

It sounds like I might have done this before.

I would like to see if I can help you, but it would be helpful if you could post up a dummy workbook.

Thx