Updated list from multiple sheets

[ningo]

Hi Folks,

I am new to the forum, but not completely new to Excel

I have a question to which I can't find an answer myself.

a workbook containing 4 sheets, all sheets have the same format, only the number of rows and the content of the cells changes.

What I would like is a new worksheet with a macro, so that when i push the button update (or whatever)
that all 4 existing worksheets are copied to the new one, without leaving blanks etc. and this even if you have previously added items to one of the 4 sheets.
Is that possible. Can someone please guide me in the right direction.

The final goal is to have 1 huge list which is composed of the 4 sheets

many thx

 

[ningo]

I have not altered the code!
But i adjusted my sheets to have the titles in the rows you mention (master sheet row 2, the rest row 1)
Each sheet has about 350 rows and 10 columns

Can you include the code as you have altered it (If you have altered it)?

Also How many Columns do Sheets 1 - 4 have?

 

[ningo]

How could i get that done?

 

[Redwolfx]

Sorry for the Delay, Try This...

Sub NewButton()
Dim Sht As Worksheet
Dim Rng As Range

Worksheets("Master List").Range("A5:J" & Range("J" & Rows.Count).Row).Clear

For Each Sht In Sheets
If Sht.Name = "Master List" Then
Else
Set Rng = Sht.Range("A5:AJ" & Sht.Range("J" & Rows.Count).End(xlUp).Row)
Rng.Copy Destination:=Sheets("Master List").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End If
Next Sht
With Sheets("Master List").Range("A5:J" & Range("J" & Rows.Count).End(xlUp).Row)
End With
ThisWorkbook.Save
End Sub