Hi.
I am currently building an Excel workbook with sheets where I enter data from different customers. I have one "main page" where I want to continually have a summary of specific input from all my sheets (e.g. customer name x, customer name y etc.).
I understand how to make a simple sum function to summarize data from my current sheets, but is it possible to make a formula/function to include all future created sheets if all variables have a fixed placement in each sheet? (e.g. if I always summarize data from cell B4 etc.)
Attached is a sample workbook where I try to explain. Hope that helped.
Hope my question made sense and that someone know the answer to this.
Thank you.
Bookmarks