title: Sum up values from different worksheets
body: <p>I'm building the budget template in Excel. In the Summary sheet, I want to sum columns from different worksheets by the corresponding cell.</p>
  <p><a href="https://i.stack.imgur.com/3B4ev.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>In my way, I get all sheet names (by VBA code, it will automatically update when creating new worksheets), then use TEXTJOIN to have all reference cells I want in a text. It looks like this: Sheet1!$B$2,Sheet2!$B$2,Sheet3!$B$2,Sheet4!$B$2,Sheet5!$B$2,Sheet6!$B$2,Sheet7!$B$2</p>
  <p>I guess we can have some way to put that text in SUM function in Excel to sum up all reference cells value, but I haven't found how to do that yet.</p>
  <p>If anyone can have a look and give me a solution, it's much appreciated.</p>
  <p>Thank you as always</p>