Export sheets to new workbooks

Helloto everyone! I have a workbook that has many sheets and i want to export them as a single workbook. The problem is that at the first workbook all the sheets start from the B7 position and i want to start to the all new workbooks from this position and not the A1.

here is the code so far

Please Login or Register  to view this content.

Welcome to the Forum, please take the time to read the Forum Rules & in future wrap your code with Code Tags.

If you are copying the sheets then the first cell will be the same .