Combining Tabs into one sheet

[Dan Morris]

I'm using Excel 365 on Window 10.

Hi Folks

I'm fairly sure that this is easy and I've been trying to use the COMBINE funtion and follow guides that I've found online but I'm not making it work so would be very grateful for some advice.

I have a spreadsheet with entries on different tabs - each tab includes sets of dates, text fields and formulae. Each tab is in the same format.

I'd like to automatically have a tab that pulls in all the data from all the other tabs into one combined set of data.

Thank you for any help and advice. Best wishes, Dan

 

[arthurbr]

Perhaps Combine Data From Multiple Worksheets into a Single Worksheet in Excel