i would like to use a saved query in more than one worksheet to retrieve data
from more than one ODBC data source.

however when i copy the query between sheets it does not give me the option
to change the data source.

is this possible wihtout renaming the query seven times and and pointing it
at seven different sources?

Any help would be appreciated.

thanks