I've got a stack of code to generate reports for sales advisers. One
workbook containing one worksheet per sales adviser.

I've also got code to bulk up these reports into teams, so one workbook per
team, with one worksheet per adviser (worksheet name = adviser name).

What I want to do is put in a summary (or manager) sheet on the team workbook.

As all adviser sheets are structurally the same, it's just a case of making
formulas which look at the same point on each sheet, so something like
=SUM(First Sheet:Last Sheet!H:H)

Thing is, I don't know how many sheets there will be, or what they'll be
called.

I've wondered about doing it as follows:

Define a variable to hold the first sheet name, likewise the last sheet
name, then bung in the manager sheet and set the formulas to the variable
values.

Thing is, how do I get the first and last sheet names into variables? (Esp.
the last - thet'll be the difficult one)

Any help you can give would be great.

Cheers,

Tom.