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