Consolidating 2 Excel Workbooks into one workbook

[angelicah]

I am trying to consolidate 2 Excel workbooks that have multiple tabs. There are 2 people working out of the same workbooks each saved to their own computer but not necessarily working on the same tab. Anyways, once each person has worked their sections then it is time to combine the tabs in which one person usually copies and pastes into the other persons workbook any items they have made comments on along with any files such as PDF, Word and Excel files that have been inserted next to the comments as support. The workbooks are the exact same except for comments that are entered into the cells starting with cell E on each tab. I have tried using the Consolidate function with no luck since the data does not start on A1 and skips lines in places I am not having any luck with this. If the person working in the workbook notices any items that stand out they are entered in the bottom of the spreadsheet that link the comments to a main tab within the workbook. Long story short I am trying to figure out a way to consolidate data from 2 workbooks in the same format instead of copying and pasting each set of data into a new workbook or existing workbook. Any help would be greatly appreciated.