Import a spreadsheet where the name changes

[sbatty]

Hi all new to the forum and hope you can help my issue is i want to import a workbook into a new sheet on a different workbook but the name of the imported one changes hope this is clear.

Can anybody help

Simon

[aydeegee]

Hi sbatty

Welcome to the forum.

The way I would handle this is to open both workbooks and then copy from one to another.

Will this work for you?

Regards
Alastair