Hello Experts,
I am new to Excel and VBA, i have a question pertaining to the split
sheets.

I have a output file called output, my wkb has one sheet/tab called
'MIS'

I have a macro to pull in the output file and add it to the workbook.
my wkb now has 2 sheets/tabs.
OUTPUT and MIS

i have a macro that has split that 'output' sheet into many sheets
given a unique value in the output sheet. It is actually the
department, so i have multile sheets that have the different depatments
in one workbook.

the tabs could be as follows...
output / MIS / 01-210 / 01-215 / 01-220 /..etc/ (could be 20
departments,it just depends on who ran the report to get the output
data.)

Now, the MIS sheet is still blank...

The users can make adjustments to their department sheets, i have a
diolog box that has a button.
I want that button to take ranges from the department sheets and put
them into the MIS master sheet.
The ranges of each sheet will be the same columns but the amount of
rows will change.

So i would copy:
All the sheets (depts- 01-210,01-215,01-210,etc...) will use columns
A,F,G,H,I,J ,but won't know how many rows.

and then paste to the MIS sheet
to the colums A:F


[I have tried doing the recorder but I can't do that since i won't know
exactly what the tabs or departments will be until i split the sheet.
multiple people will use this and the departments will be different for
each one doing the splitting. ]

I hope that i am explaining myself okay...so now...i am stuck, i don't
know the tab or department until its made, so how can i automate this?


Thank you for taking the time to help me out here, since i am new. Any
help would really be appreciated.

Keri