I'm stuck on the best way to prompt the user to open another workbook and
select a worksheet to be copied into the file containing the macro. Ideally,
I would hardcode the name of the target worksheet, leaving the user to just
locate the right file.

However, I need to include something that will also allow the user to select
the specific worksheet to copy, just in case there's been some unauthorised
tinkering.

Is this possible?

Many thanks for your help