I have a Massive spreadsheet with a few dozen tabs that i want to simplify

[edwmetro]

Each tab represents an aspect of a department. Each Department needs info from several tabs and some overlap. There are a total of about 8 departments. I want to create a macro that Formats each tab to simplify it, then pulls out the data for each department into a separate workbook reducing each workbooks size and simplifies it as a whole.

Is there a simple macro to pull out specific tabs ? then create a summary tab for each new workbook?

 

[HackSlash]

This is a really vague question. "Simple" is relative to your VBA skills. Do you have any code you are working on?

Moving a tab to a different workbook is very simple, just record a macro of yourself doing it and then look at the code:

https://support.office.com/en-us/ar...Recorder-974ef220-f716-4e01-b015-3ea70e64937b

NOTE:
When you have overlapping data I would recommend organizing the data by data type and not department.