Set Ms = Wb.worksheets.add (After:=Wb.worksheets (Wb.worksheets.count)) Ms.name = Main.

Click on the data tab and then click on consolidate. When you find the data you need, click on add. Continue in the same way for each dataset that you would like to merge.

First, We Set Our Wb Variable To Be Equal To The Active Workbook, So We Can Start Working From There.

In the reference section choose your spreadsheet in order to be able to access your data. In the function section, choose sum. This part of the code sets our variable ms (we said this variable is for our main sheet), and adds it at the end.