Export from old. import to new template/workbook

[hassoe]

Hi everybody

I have a small task that i need some help on. I need to make a function that will take data from one sheet in one workbook, and paste it into a new workbook/template sheet.

-Each sheet are alike, and the data in question starts from B8 and ends at O500.
-Some of the fields may contain more the 250 characters.
-And how can it be made so that the function ask the user to select the file containing the data?

The number of sheets might expand over time, so it would be great whit a function that focuses on one sheet at a time, so it can be copied if needed for a new sheet.

Thanks in advance!

Regards
Niels