My dilema is that I have a cumulative 3 month rolling report that takes input
from 3 seperate workbooks that contain 12 worksheets each.

The cumulative report cells have multiple hyperlinks (up to 9) back to the
individual workbooks. eg.

=SUM(IFTA\Sledge_IFTA_2008\[Truck Logs (10-08).xls]1565'!$M$33,
IFTA\Sledge_IFTA_2008\[Truck Logs (10-08).xls]1565'!$P$33)

I need to be able to substitute in both the month (10-08) and also the truck
number (1565). If I can code the month & truck number onto the worksheet say
in $A$30 and $A$31 I can reduce my hardcoding hyperlinks by a massive margin.

I keep seeing examples of VLOOKUP/INDIRECT but can't get the formulas correct.
Am I barking up the wrong tree ???
--
English geezer living in the USA