put all sheets in one

[Guest]

i need to put the numbers of all the sheets i have created onto one sheet
have this done automatically is there anyone out there that can do this

 

[Kelly O'Day]

Laura

This is very doable with a macro.

You set up a consolidated_data sheet and a loop to cycle through all of you
source data sheets copy target range and paste to next blank row in
consolidated_data sheet.

Is the layout for each source sheet the same? How many sheets? All sheets in
book or selected sheets? Will you be doing this one time or repeatedly?

Do you know VBA or do you have access to a VBA programmer?

The answers to these questions address whether you are better off doing it
manually or with a macro.

For < 10 sheets, may be quicker to do it manually.


...Kelly