For example, I have a date column in current sheet (overview_sheet) and a count column, the sheets are named the same with the addition of a date behind it to differentiate each sheet eg. sheet_0714, sheet_0715
For the count column cells, I use functions like =sheet_0715!H20 manually to get the value from the other sheet, but is there a way where I can change the date part of the function dynamically based on the date of the row?
so, =sheet_(date)!H20 where (date) is based on date of the row in current sheet
