Conditional sum over multiple sheets

[Loops999]

I'm new to this so sorry if this is in the wrong place.

I have a workbook to track expenses for a team.
Each team member has their own worksheet. The worksheet names are the names of the team members, the name is also shown in cell G4 of each sheet.
All sheets are formatted the same. More sheets may need to be added in the future if the team expands.
Example of information is Hotel, Fares & Travel & Car Hire in columns S, T & U respectively.

I have a summary sheet where all names are listed, I need a formula that will sum columns S, T & U for each name in the summary list but want to also be able to add more worksheets in the future without having to re jig formulas. Is this possible?

[NBVC]

Maybe something like:

=SUM(INDIRECT('"'&X1&"'!S1:S100)) for defined range

or

=SUM(INDIRECT('"'&X1&"'!S:S)) for whole column.

where X1 contains the name of the sheet you want to reference.

formula can be copied down

Do similarly for columns T and U.

[Loops999]

Thanks for this but I get a message saying the formula typed contains an error when I try to enter it. Not sure if I'm doing something wrong?

[NBVC]

Try:

=SUM(INDIRECT("'"&X1&"'!S1:S100"))

[foxguy]

Loops999;

I'm betting that you're having trouble interpreting all those apostrophes and quotes.
The formula is:

Please Login or Register  to view this content.

Notice that there is an apostrophe(') surrounded by quotes, then an apostrophe(') !S:S inside 2 quotes. When you type it remove the spaces and it will look like Comic Relief's formula