I have a workbook with many spread sheets. The spreadsheets are linked to
one sheet that totals all the volume.

=SUM(Kent:Theyagaraj!F6)

Kent:Theyagaraj is the range of tabs I need to calculate, this is on the
total volume spread sheet.

=Abramowitz!F6

Is the name of an individual spreadsheet and the range/cell I need to have
the info transfer to the bigger spread sheet. (Abramowitz is in the range
(kent:Theyagaraj)

These links have been in place for years...each FY we copy the worksheets
over...just suddenly started having a problem.

Any help would be great.

Thanks so much and have a great day.
--
Jules