create multiple work books with multiple tabs

I am trying to setup a macro that will take my original file that includes multiple sheets and split it into multiple workbooks with the same sheets based on a name entered into a column on the first (main) sheet. I have been able to create a macro that will create multiple workbooks for one sheet but not for multiple sheets (see below). The main worksheet will contain unique data, but the other worksheets will just need to be copied to the new workbooks. I also need any links on the main worksheet to remain intact (linked to other sheets within the workbook as opposed to linking to the original workbook). Pleaee help if you can. Thank you.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

What browser are you using?

How big is your file? You cannot upload a file more than 1mb.

Also are you using the basic uploader or enhanced uploader? Check UserCP -> General Settings -> Enhanced Attachment Uploading -> Select the Off option.

Can you please explain your question with the help of your file. Am not able to understand it.