Storing Sheets Names for loop
 

Hi,
I have multiple sheets with info. I need to add a sheet at the beginning
called "Combined Total" and then copy and paste however many rows from all of
the other sheets except for the one called "Total" and paste it together on
the "Combined Total" sheet (the "Total" sheet is a summary not a roll up
which is why I need to make a roll up).
Thank you.

Storing Sheets Names for loop
 

What is a "roll up"?
I think you are saying that you want to copy all the occupied rows from all
the other sheets (except the Total sheet) and paste all that data in a sheet
named Combined Total. Is that right? HTH Otto
"skunkdunk" wrote in message
...
Hi,
I have multiple sheets with info. I need to add a sheet at the beginning
called "Combined Total" and then copy and paste however many rows from all
of
the other sheets except for the one called "Total" and paste it together
on
the "Combined Total" sheet (the "Total" sheet is a summary not a roll up
which is why I need to make a roll up).
Thank you.