separate tabs

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...

My workbook has two workseets that I need to split by an area and then save each new workbook under the areas name. Before anyone says combine the two sheets to make it easier we can't; we have to have 2 separate sheets for this particualr report Start File: This is the file that contains all...

I apologize if this has been answered, however I've spend a few hours trying to get something to work. I am using Excel 2010 and am trying to combine multiple files in separate subfolders into one workbook with each file name as a separate tab in a new workbook named the same as the subfolder...