How to merge multiple tables into 1 master table?

I will be having an identical table (format / column names / etc) in multiple sheets. In one sheet I would like to take the entries made in all the other sheets and have them all listed in this new master table.
Scenario explanation:
I would have a separate sheet for each month and in each of those sheets I will be recording the sales completed that month. But then in the master sheet I would like to have all sales listed together.
Everywhere online seems like it will answer this question but it never seems to be this situation - they tend to be talking about merging table columns (so adding additional columns) and stuff.
So sorry if this is a simple/stupid question
Thanks in advance

It can be done with a few formulae, but it would help if you attached a sample Excel workbook so we can see exactly what data you want to bring across to the master sheet.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon does not work.

Pete

So I only have one sheet made and it's one month and it shows how the sales will be recorded. I have not created additional months or made a spot for the master sheet because I did not want to go further if it would not be possible to do this. Would the one sheet I made suffice?

So I followed your steps - hopefully it worked.

I presume you want to show the yellow area(s) i.e. columns J to Q from each sheet in the master sheet.

How will your Month sheets be named? You could just use Jan, Feb, Mar etc. i.e. 3-letter abbreviations of the month name, or you could use the full month name, but then you will only be able to have one year's data in a file, and you will need to start a new file in a different year. Or you could have Jan-17, Feb-17, Mar-17 etc. for the sheet names, and then you will be able to accommodate many years in one file. I need to know the format of the names as I will be accessing the data from them.

How will your master sheet look? Will this be exactly the same format, with column C showing the summary information, and if so will you need the blue areas for time tracking? (I'm not sure what that is there for).

I'm thinking of adding one more column to the Month sheet which will identify unique records, and will do this from one sheet to another in sequence. Then the master sheet will be able to pick up on these sequential numbers to collate all the information in one sheet. The master sheet will also include a lookup table of sheet names and records per sheet, and will have two helper columns. I hope this is a satisfactory approach.

Hope this helps.

Pete

So, I guess teaching is not something you're willing to do?

Sorry for the delay in getting back to you. I'll take you through the initial steps.

The idea is to set up a sequential number to identify records which match the criteria, and to pass that numbering across to the other monthly sheets, but it would help if you first of all renamed the Month sheet to Jan-17. Then you can put zero in cell A8 and this formula in A9:

=IF(J9="","-",MAX(A$8:A8)+1)

Here the criteria is just that column J (yellow Date) has something in it, but if you copy this down to A68 you will see those sequential numbers appear where you have data in the table. Incidentally, you can always hide these formula/values by applying a grey font colour after you are sure everything is working as it should. I would also suggest putting this formula in cell A1:

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

and this will give you the name of the sheet that it is on.

Then you can just Ctrl-drag the sheet to produce a copy, and rename it to Feb-17. In this sheet we don't want the counting to start from zero in cell A8 - rather, we want it to start from where the last sheet had got up to, so to help us with that this formula can be used in cell C1:

=TEXT(DATEVALUE("1"&A1)-1,"mmm-yy")

and this returns the filename of the previous sheet. We can then have this formula in A8 of the Feb-17 sheet:

=MAX(INDIRECT("'"&$C$1&"'!A:A"))

and you can see that the numbering will carry on consecutively for the matching records. This sheet can now be copied again and renamed as Mar-17 to confirm that everything is working as it should. Obviously, the next stage then is to keep doing this until you have sufficient monthly sheets to meet your needs (clearly, the data in the yellow area will need to be deleted and the appropriate data put in instead).

Let me know when you have got that far.

Hope this helps.

Pete

Yah, I will be changing the names to Jan17, Feb17, etc.
However, I cannot guarantee that this will be the final format.
And yes I was talking about the yellow portion, however I will be doing the same thing for the blue portion.
I used this sheet to give an idea of why I need to do this. But I would really just like to learn the concept on how to do it. I'm not asking you to do it for me. I would like to learn how so I can do it on my own in the future because this is a concept I will be using a lot.
And having a unique identifier column is fine I can call it TX# or something.
Anyways, hopefully that all made sense.