Hi,

So I have a workbook with a ton of sheets and the underlying data for these sheets is updated every so often. The problem I am trying to solve is that if someone completes the workbook in an older version and then wants to simply transport all of their work into the newer version, how could they easily do this (ie., hit a button to do it for them)?

Essentially, I need to conditionally copy/paste data from the old workbook to the new one for almost every single tab in the workbook. I say conditionally because new columns might be added, thus a simple copy/paste macro won't work because where the data belongs might change. I would need the macro to make sure the data it is pasting from the old workbook goes into the correct/matching column in the new workbook. The column headers SHOULD always be in the same row

I'm not even sure where to begin, I am still pretty new to VBA, so are there any threads already exisiting on this topic? Or does anyone have some ideas of where to start with the code? At least with a starting point I could try expanding it to the other sheets.

Please let me know if you need any additional information and thanks!