Dear forum experts,
I have this issue of many worksheets (up to +20) and one sheet that has to sum it all.
I need a formula that look for the sheet name that = cell value and then gets the value into the correct row.
If the cell (A1) has text string of " Shop 01 Andrew" then look for sheet with same name and get the values from row range
I attach an example file with a result as well
Regards
Bookmarks