Importing data from old workbook into updated version of same workbook

I have a massive character generator that gets updated frequently, and users have to start over each time I send out an update. Users make a lot of choices from data validation lists, but there are also tons of metadata that does not need to be imported. Is there a macro that will take just those unique choices that are made (these are spread all over the place, over multiple worksheets...they aren't simply residing in a nice, neat table) and import them into the newly-updated workbook? Will I have to specify each cell (and worksheet?) that I want to import?

Thanks in advance,
Jon

Thanks! Bonus points if you can provide either code or a link to a good example, as I am terribly inept at VBA. Parameters:
Filenames, the same: Generator (I assume the paths need to be spelled out, or if you could browse to find the file, that would be preferable in case user changed the file name or older file)
A few example Cells to be copied (which go to same cell in new file): Race(a named cell in worksheet 'Character Setup'), 'Character Setup'!O7:O12, 'Character Setup'!J5, 'Level Up'!P9. I have countless more, but I should be able to extrapolate with these few examples.

Peace.

I found some code online that I modified below. It works great…but I have some questions due to my atrocious VBA skills:

1. Do I need everything in the ‘Last cell in column section? I have no idea what that does. I’m just updating an old spreadsheet with a newer version, and I’m simply importing the old info into the new spreadsheet.
2. Is there any way to make this more efficient, perhaps by selecting multiple ranges and doing the copy in a single command? I need to add probably 20 times the amount of range copies that you see below, and I’m concerned about performance.
3. I have several other worksheets to copy from/to as well. Am I better off creating separate macros for each worksheet, or should it work fine inside of a single macro?

Thanks so much for your help!

Please Login or Register  to view this content.