I've spent a couple of hours searching this group but I can't seem to
find a solution that works!

I have a workbook with sheets named with dates, but let's call them
"A", "B", "C", "D" etc

I have a 'from' date in cell A1 and a 'to' date in cell A2, so let's
say these are 'B' and 'D'

So what I want is a formula that will sum cell F8 on each of the
sheets in the range from 'B' to 'D'

I know using INDIRECT and SUM doesn't work, but from reading this
group I think there's probably some way of using SUMPRODUCT but I just
can't get anything to work. Any help greatly appreciated!