Bring in data from specific tabs to one data tab

[mnadams]

Hello,
Any assistance anyone can provide would be great.

I have a workbook in which I need data from 5 specific tabs pulled in to one data tab within the same workbook.

The data destination tab is named "data"
and the tabs that I need data from are named:

1. NA
2. EC
3. ME
4. VJ
5. TK

After I get all data in the "data" tab, I plan to create a pivot table based on the data. I have tried several attempts at the code but I am running in to errors when trying to call out specific tabs versus pulling in data from "all" tabs.

Thank you in advance!

 

[VoG]

Try

Sub atest()
Dim ws As Worksheet, j As Long
Sheets("Summary").UsedRange.Offset(1).ClearContents
For Each ws In Sheets(Array("Jun", "Jul"))
    j = j + 1
    ws.UsedRange.Copy Destination:=Sheets("Summary").Cells(Rows.Count, j).End(xlUp).Offset(1)
Next ws
End Sub

 

[pedro-egoli]

That did the trick .
Thanks again for your patience and assistance.

Pedro