I have a workbook that is updated daily. There are 10 worksheets with
individual data. Although the columns are exactly alike, the amount of rows
can vary. I want to copy all data, by rows, into one sheet for a report. I
have to be able to refresh the "master" sheet as new data is put into the
other 10 sheets. Short of copying and pasting every sheet into the master
every time a change is made, is there an easier way to automatically do this?
Thanks for any help!