Combining Spreadsheets

[drdepatie]

Situation: I'm the production manager at a small manufacturing company. Over the years, 3 different excel database to track shop work orders have been started and maintained, (WO spreadsheet, the machine shop spreadsheet and the QC daily log spreadsheet). They each have different and relevant info but all have the WO number in common. They're each over 500 rows long. I'd like to combine/merge/consolidate/whatever them into one master spreadsheet but I'm hoping there's an easy way to do it without doing one line at a time.

Question: How do I combine them into one?

Thanks,
Dave

[sweep]

you can do this by using the index and match combination in Excel. If you need help, please post an example of the workbooks you have.

Dave