G'day Excel Forum,

First ever post on the forum so I hope I am not asking a question that has been answered before (have tried searching).

I am trying to write a formulae which has a relative sheet reference.

I am trying to put into one column the values from the same cell over multiple sheets (approx 168 sheets)
I was hoping to pull down the formulae so that the sheet number changes each time
eg:
Sheet1!$B$5
Sheet2!$B$5
Sheet3!$B$5 etc

Is this possible?

Greatly appreciate any assistance