Consolidating data from multiple tabs into one continuous table on separate sheet

HI, I have something and I am not sure whether what I want to do can be done or not!

I am doing something which software should do for me but doesn't and I understand it is a horrible way to work on something but I have to work with what I have!

I have a spreadsheet with agent activity for calls on separate tabs and I need to collate the data on into a master sheet but I don't understand how to use queries or power pivots all the columns are the same on each data tab - I have added an example can someone help me do this in a simple way?

in my example Master sheet example tab is what I want the data to look like if possible!

Thanks J

Hi Alan, i don't have power query I am using Excel 2016 which has get & transform and I have never used either. would it be possible to break down the steps for me a bit more? How do I Load each table to Power Query for example?

Sorry I am a complete novice with power query!

Thanks

J

Hi Alan, that has worked perfectly and done exactly what I need. Thank you! I have updated my profile to show Excel 2016 as well.

Thanks so much

J