Hi,
Ron has a macro to do that look into

http://www.rondebruin.nl/copy2.htm


"nitengale" wrote:

I'm sure there is a formula out there to do this, but I'm not finding any
help in the help function in excel.

I have one worksheet for each day of the month with data. I'm looking to
take the data from each of those sheets and dump it all into one "summary
sheet" instead of having to copy and paste each day (I'm not looking to
summarize any of it). If a new sheet is added, I would like to have the data
added to the bottom of the "summary sheet"

Any suggestions as to how to do this?