I have spent hours looking for just the right tool/vba code to do this. I have found many articles that do almost what I need but not exactly. I am not an Excel expert on Consolidation, Pivot Tables or VBA and really hope someone can supply me with the exact code or steps to get this done.

I am using Excel 2010.
- I have a workbook with 4 worksheets called: PSRM, ProgDel, Benefits, Other.
- Each sheet is set up the same way: A1 is a title, A2 is blank, A3 is the column headings (all 4 sheets use the same headings), A4 is where the data rows begin.
- This is key: the number of data rows will differ on each sheet, so I need to copy the data without setting a specific range (currently the data is in a table on each sheet).
- I would like to set up a summary page where the first 3 rows are reserved for a title, date and other information such as a count of the items on the page. The data on the summary sheet should appear beginning at A4.
- When the 4 worksheets are updated, refresh the summary data ONLY (I don't want to delete the summary sheet each time there's a refresh because then I would lose the formatting of the summary sheet).

I am familiar with copying and pasting vba code, running macros and with instruction can adjust some code if it is obvious (e.g. change Sheet1 to "NameofYourSheet", etc.) I've tried Consolidation and Pivot Tables and either it didn't work or it didn't give me the desired results. Any assistance is appreciated!