Raw Data of Daily Sales in different-different monthly Sheets
Formula: =VLOOKUP(“TOTAL”,INDIRECT(B3&”!A:D”),2,0)
Output After Applied formula to make Monthly Summary
Video Tutorial
Download Practice File with Formula (Download.xlsx)
How to Enter All Sheets Monthly Total Summery in a New Sheet
Thank you for all you doing