External Data Query Parameter - How to Set to Cell in Current Worksheet?

[rxp19]

I created a query to pull external data.

I set the query to get the value from cell A1.

The problem is that when I attempt to copy and paste the data connection cells from a template to a new worksheet, the query always attempts to pull the data from ='Template'!$A$1, rather than A1 of the current worksheet.

When I enter =A1 in the parameter of the template, it always adds ='Template'$A$1 in the parameter field.

How can I set the parameter of an external data query to cell A1 of the current worksheet?

 

[rxp19]

Do you know if I can write a macro that would force the iqy file to reference cell A1 without having excel append the name of the worksheet template?