Use tab name in formula

[julhs]

Want formula to sum the same cell across multiple unknown number of sheets where the last 5 digits of the sheet names match the last 5 of the active sheet

Tab names=
Jane 16-17
Fred 17-18
Joe 17-18
Mary 17-18
Fred 18-19
Joe 18-19
Mary 18-19

Active sheet = Joe 17-18

Cell A1 on Active sheet = Sum(Joe17-18,D1+Fred 17-18,D1+Mary 17-18,D1)

 

[julhs]

I've just deleted the code in module and re copied your code back in and its now giving the expected result.

So now may never know the cause of the #value error.

Many thanks for your help

 

[Eric W]

I'm happy we could help.