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