Pull data from external workbook

[JimDandy]

I have a rather large template that I update from time to time. In doing so, I'd like to be able to pull data into the new template from an existing file. I'd like to have a button in the new template that prompts the user for the file name of the old template, and then pull data from the old file into the cells of the new template. In order to accommodate the possibility that the new template's cell's data location might be in different places from the old template, I would like to be able to control the range of the source and destination cells. Also, the ranges are not contiguous, so I cannot use A1:D15 style ranges. It needs to be Range("A1, B2, C3, D4") as an example (although in my examples they are contiguous, in my larger template they are not)

Also of note, the worksheets in both workbooks are protected except for the cells I'm drawing from and copying to and there are multiple worksheets but I would only be pulling data into a worksheet by the same name that exists in the old.

Can someone suggest code that makes this possible? I have attached a couple files that can be used to demonstrate the possible options if that helps.

[Leith Ross]

Hello JimDandy,

If your actual template is different from the one you posted, you should post the template the macro needs to modify, unless you just want some example code which you can expand upon.

[JimDandy]

The actual template is way different and has a few dozen cells in sections across each page but I can interpret and expand on any code if given enough that solves the problem for the examples I provided.