Import data and rename sheet

Hi Excelforum,

I have multiple template sheet with a button to import.
The idea is that every time another workbook is "picked" the corresponding data form the sheet "summary" is imported into the activesheet with the button.
I, however wan't to rename the activesheet with a part of the filename from other workbook e.g. workbook to import Test_somthing.. then after importing the data "Test - Summary".

I know I am almost there but especially the renaming of the sheet is a problem.

Please Login or Register  to view this content.