Import a specific sheet from multiple workbooks

Right now I have a macro which I did not write from scratch that lets me choose a folder and then pulls in all sheets from all workbooks in that folder.

I need to ammend this so that I pick up a specifc sheet which is named the same thing in each worksheet. I also need to bring in the contents of this sheet as static as it currently has formulas in there.

Here is the current code I use, I'm not sure if it would be easier to ammend this or start fresh.

Please Login or Register  to view this content.

Any help would be really appreciated.

Thanks