Copy dynamic range from closed workbook

Hi everyone,

I have the following the problem.

I've got Workbook A and I want to copy a dynamically named range consisting of multiple rows and columns, with the number of columns increasing, from Workbook B which is closed, to Workbook A. I don't mind automatically opening/closing Workbook B in the background in order to get this. I want to link this to a button such that if I click the button, the cells are copied etc; I don't want it to continuously update. Or even more preferably I'd want it to copy the cells when Workbook A is first opened, but I don't know how to do that!

I can do the button work and I know how to copy a defined cell range from a closed workbook, but I don't know how I'd do it for a dynamic range.

Any help is greatly appreciated.

Thank you!

EDIT* I can do the on opening workbook bit.