I have several workbooks in a folder. Each has a transaction worksheet and a summary worksheet. The number of rows of data in each summary sheet differ from workbook to workbook but all fall within a dynamic range having the name "AData". I would like to consolidate those summary records into a separate workbook. Formulas do not seem to be the most efficient solution but I welcome any suggestions. I believe a macro may be the better solution and for that I am a little lost. Can anyone help?