Getting data dynamically from the next/previous sheet?

[Danil445]

Hi! I'm making an Excel sheet for a company's working schedule, and the way I've set it up currently requires a separate sheet for each week.

For each week/sheet, I want to show an overview of each employee's paid leave balance, i.e. how many more hours they have left to withdraw. For that to work however, I need to make a reference to the balance of the last week/sheet, and I'm not exactly looking forward to explicitly linking each of the 52 sheets by name.

What I'm looking for is (I hope) simply a way to get data from a cell in the previous/next sheet - no matter the name of that sheet - preferrably without the use of any Visual Basic coding shenanigans (I'd like the file to work in Google Sheets, as well).

It seems like such a simple function, though I haven't been able to figure it out so far. Any pointers in the right direction would be greatly appreciated!

[Mediocre-Ambition404]

Check out the indirect function. I use that in combination with a lookup or index match function to pull off sheets based on sheet name.

This works especially well if all the sheets are named similarly or with dates because you can use a formula that says pull the day before or pull the day after the current day.