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