Hi,
I hope someone can help me here.
I have a lot of sheets in one spreadsheet, Sheet 1 (Week 1), sheet 2 (week 2) etc etc.
This will continue to be more until the end of the year so it will be Nth week.
sheet.png
Each sheet (week 1) etc etc, have data.
data.png
I want to have one sheet (Report (2018)) to have all the SUM of total number from week 1, week 2 etc etc
data_2.png
So on (Report (2018) sheet) "HD Order Qty", excel will check week 1, week 2 on so on and so fort for "HD Order Qty" then sum it all and the sum will show on (Report (2018) sheet) which is the first sheet.
I hope I was able to explain clearly my problem.
PLEASE HELP!!!
Bookmarks