Trying to create a summary sheet from multiple tabs but get "no data was consolidated"

Hi,

I wonder what i so wrong. Trying to create a summary tab with data from multiple tabs but receive "no data was consolidated"error all the time.
I have checked that the sheets look exactly the same (same headers etc.)

I have attached my excel in case someone would figure out what is wrong

Thanks a lot in advance.

-Leevi

Hi Leevi90,

Can you add some data to your Summary sheet so we know what you are after.

Regards

peterrc

Hi,

I think consolidating is actually not what i need to do. I am trying to summarize data from multiple tabs into the sumamry tab.
The idea is to gather all the data from all the tabs in the sumamry sheet (emails, and peoples names).

So it is maybe VBA I need to do?
I found this:
'In this example I am Copying the Data from Sheet1 (Source) to Sheet2 (Destination)
Sub sbCopyRangeToAnotherSheet()
'Method 1
Sheets("Sheet1").Range("A1:B10").Copy Destination:=Sheets("Sheet2").Range("E1")
'Method 2
'Copy the data
Sheets("Sheet1").Range("A1:B10").Copy
'Activate the destination worksheet
Sheets("Sheet2").Activate
'Select the target range
Range("E1").Select
'Paste in the target destination
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

I tried to enter it but didn't work. I'm so lost :D So grateful if someone can help me.

-Leevi