Use cell data as table name in formula

[BobSullivan]

I have monthly data in worksheets. Each worksheet contains one table, the table name is the month name. There's a January table, a February table and so forth.
On a summary page, I have the month names in column A. In column B I want to calculate the totals of a column called "Total" from each table.
So the worksheet would look like this:
Column A Column B
January =SUM(January[Total])
February =Sum(February[Total])

and so forth. What I would like to do is have the formula in Column B use the text in column A as the table name. That way, I could easily copy the formula down for all 12 months. How can I use the text in a cell as a table name in a formula?

Thanks!

[BobSullivan]

Found my answer. The way to do this is to create the following formula:
=SUM(INDIRECT(A1&"[Total]"))
The table column needs to be part of the indirect function.

[HansV]

Good for you!