Address of entire column for dynamic list

I am trying to write a few dynamic lists, based on data in a sheet, using the standard

Please Login or Register  to view this content.

But I would like the column $A:$A to be dynamic as well based on a named variable.

i.e. the named variable is called "ListTitle"

and so code is now something like

Please Login or Register  to view this content.

I tried using the "address" formula, but this doesn't seem to accept anything other than a single row address, so is inappropriate.

If anybody could help, that would be great.

ListTitle is currently defined as =Sheet1!$A$1, but I will want this to be able to change as and when I add an additional header across the top of all lists, or when I add additional lists.
I know excel does a lot of these changes automatically for me, but I will want this to have the flexibility, hence why I am using the named variable approach, and not just the direct reference to the cell address.