I have a couple of spreadsheet that I have built and this spreadsheet will be used by 20 different locations. But I will have also 4 sub levels which will be using the data entered by the 20 locations. Those 4 levels have 5 locations each. I would like to set up the sheet, so all the date could be routed directly from the 20 locations to the next level without any interactions between the 2 levels.
Also, I would like to create a master sheet that summarize the 4 levels and the 20 in the same dashboard.
I will need also, some calculations and graph to be fixed in the report.