I have a question regarding data in several worksheets in an excel file. The sheets all have the same number of columns with headings but differing amounts of rows. What I would like to do is create a new sheet in the same file that will take the data from the other sheets and combine it into a master sheet. Also, if I were to add data/rows to one of the worksheet, I would like to have the master sheet update automatically. Has anyone done this before and if so how can it be done? Thanks in advance for all of your help.