Copying a row from multiple sheets to a summary sheet

[etaaroa]

I have a budget workbook that consists of multiple sheets that are all formatted identically and I need help to create a macro that takes one line (money expected to be received for Jan-Dec) from each sheet to create a summary page. Each tab is labeled with a name and the range from each individual sheet that I need in the 2012 summary is A112:M112. The individual sheets are updated from time to time, some are deleted and some are added, so the summary would have to account for this.

If possible I would also like to create on another sheet for a 2013 summary taking the range of A119:M119 and then for 2014 summary taking the range of A126:M126. Of course these summary pages would have to exclude the other summary pages when compiling the data.

I would appreciate any help with this! Thank you so much.

 

[etaaroa]

More specific info may be needed - I want the info to end up on the summary sheet beginning in cell B1. Each tab on the individual sheets are labeled with the names (about 80), which are constantly changing, so the formula can't be dependent on the sheet names, it just has to take them all (except for any other "summary sheets")

 

[etaaroa]

In case anyone has this same problem, I found a code that works great, just input your own summary sheet name and range:

Sub SummarizeSheets2012()
Dim ws As Worksheet

Application.ScreenUpdating = False
Sheets("Summary2012").Activate

For Each ws In Worksheets
If ws.Name <> "Summary2012" Then
ws.Range("A112:M112").Copy
Worksheets("Summary2012").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial (xlPasteValues)
End If
Next ws
End Sub

 

[brettdj]

The free ASAP Utilities addin, www.asap-utilities.com ,offers a neat menu driven solution for this

- download and install the addin
- use the 'Sheets' ... '23 Put togther rows or columns from several sheets' option

Cheers

Dave