Sum columns on multiple sheets

[Rob_010101]

Hello

Using the basic salary column on FY 22-23 as an example, I need a formula to sum this column into basic salary on the stats sheet, if possible using the sheet name in column A as a reference to the sheet to sum from. All columns across all FY sheets are set out the same.

Stats sheet:

Book1
	A	B	C
1	Financial Year	Basic Salary	Income Tax
2	FY 22-23
3	FY 23-24
Stats

Financial year sheet example (FY 22-23):

Book1
	A	B	C
1	Date	Basic Salary	Income Tax
2	01/01/2022	£10,000.00	£3,000.00
3	01/02/2022	£10,000.00	£3,000.00
4	01/03/2022	£10,000.00	£3,000.00
5	01/04/2022	£10,000.00	£3,000.00
6	01/05/2022	£10,000.00	£3,000.00
7	01/06/2022	£10,000.00	£3,000.00
8	01/07/2022	£10,000.00	£3,000.00
9	01/08/2022	£10,000.00	£3,000.00
10	01/09/2022	£10,000.00	£3,000.00
11	01/10/2022	£10,000.00	£3,000.00
12	01/11/2022	£10,000.00	£3,000.00
13	01/12/2022	£10,000.00	£3,000.00
14	01/01/2023	£10,000.00	£3,000.00
15	01/02/2023	£10,000.00	£3,000.00
16	01/03/2023	£10,000.00	£3,000.00
FY 22-23

 

[Leo Skywalker]

Hi there,

Try in B2:

=SUM(INDIRECT("'"&$A2&"'!B2:B16"))

 

[Rob_010101]

Hi there,

Try in B2:

=SUM(INDIRECT("'"&$A2&"'!B2:B16"))

Perfect, thanks Leo

 

[Leo Skywalker]

Glad that I could help!, thanks for the rep.