Sorting macro on dynamic column of different sheets
 

Hi!
In my form a column is populated by an indirect
formula that pulls data from different worksheets based on dynamic
info (if A=0, then WorksheetA, if A=1 WorksheetB, etc).
I have then setup a macro to sort on this column.
When i created the macro the indirect pulled from WorksheetA.
However, when the Indirect formula pulls from WorksheetB the data is
displayed properly (formula resulting what i expect), but when i hit
the button to run the macro it still sorts based on WorksheetA.

Is it possible for the macro to understand the sorting based on
different worksheets?

the column that Im sorting on has this formula
=IF(W110,(SUMIF(INDIRECT(""&$T$5&""&""&$AY$5&""), $H11,INDIRECT(""&$T
$5&""&""&$AY$4&""))),0)
If something isnt 0,
sumif, dynamically pulling the sheetname and column to pull from.


please help!!