Insert those start and end worksheets (for the sandwich).

And put your formula in a worksheet that's outside the sandwich.

Now start dragging each worksheet outside the sandwich. Check to see what the
formula evaluates to each time you drag a worksheet out.

When the formula stops giving an error, then you've found the problem.

If the formula gives an error and there are no more sheets between them, then
maybe you have hidden sheets that you didn't know about????

wrote:

No, I double checked all the "B2"s and they've all got numbers in them
I also tried the start and end sheets and it still came up with
#VALUE.
I've also tried a couple formulas with OFFSET and INDIRECT and I can't
get them to work how I want, but I've never used those before so maybe
I'm not doing it right?

--

Dave Peterson