I have 50 templates of the same format, which has multiple tabs in it, all the 50 templates have to be consolidated by summing each cell from all the templates and give a summary file.
for example: I will receive PnL templates from 30 different regions which needs to be consolidated by adding all the cells (except for the cells where i have formulas) and create a summary tab
i am attaching a sample it have to consolidate all yellow cells. the path for each file will be different, a message box will be popped up which will ask for the path of the files
thanks a lot in advance