Using a cell Reference in a table name in a formula.

[1629dill]

I am working on a spread sheet that pulls data in to a sheet from an ODC connection to an AS400 database.
I am working with a sumif formula that is puling data from the table “Table_Query_from_AS400_Data”.
=-1*(SUMIF(Table_Query_from_AS400_Data[ACCOUNT3],"S02",Table_Query_from_AS400_Data[PERIOD_1]))
I would like to change the formula so that I can put the period in a cell and the formula will look at the new period and return the data.
=-1*(SUMIF(Table_Query_from_AS400_Data[ACCOUNT3],"S02",Table_Query_from_AS400_Data[$A$1]))

A1=Period_1

 

[mole999]

something like Dim Wednesday

Wednesday = range("A1")

_AS400_Data[Wednesday]))