I need to create a summary page that will grab data from all sheet if the id number match it will only create one row in the summary page but add the base amount of each sheet and place the result on column name total investment for that id. I would like for this to update it self automatically every time i add a new sheet or add a new row to any of the sheets. here is a example of the workbook.
Bookmarks