Merging data from multiple worksheets

[aavocado]

I have data in 9 separate sheets in the same workbook which i need to combine. the objective is to merge all the data into one master sheet to be used for analysis and reporting. The data in the individual sheets will have the same number of columns and column headers. Each column represents a period (month), and has a total line at the bottom. every month an additional column will be added along with the figures for that month.occasional new rows would be added above the total row. The ideal will be for the master tab to update automatically (or with a few clicks) anytime the individual tabs have been updated. please can anyone help with a solution.
thanks

 

[sandy666]

try PowerQuery with Append feature then you can use PivotTable or DataModel

edit: to refresh result : Ctrl+Alt+F5

 

[oldbrewer]

in sheet1, cell A1, put=sheet2!A1+sheet3!A1

thus A1 is the total of data in sheet2 and sheet3

if you change A1 in sheet3 then Sheet1 A1 will automatically update