transferring defined names from one worksheet to another via data connection?

I have a workbook where I have defined a set of named variables. I have tried setting up a data connection to the worksheet. Once I have selected table (sheet) the entire data is transferred over but it is treated as one huge table. All the defined names are no longer on the new workbook.

Is there any way that I can keep these defined names on another worksheet via data connection?

Could this be achieved via other ODBC data connection schemes?

Not only I like to have the data I would like to retrieve the defined data names so I can immediately refer to them on my new workbook

I am also interested in copying the underlying definition of the named ranges. Say, on the remote excel sheet I have a named range called S1 that is defined by a dynamic formula. I would like this range and its definition to be duplicated exactly on my destination workbook. So in a word, I am not just interested in the data itself but the definition and variables of that remote workbook. I'd like a duplicate of that definition re-generated in my destination workbook, so I would be able to see, with opening of the name manager on the destination workbook, S1 with its associated definition. Is this achievable with some operation of ADO and excel vba?

What my intention of this exercise is to store a configuration file at a central location. I am going to distribute a series of vba scripts to many users. When they start up their scripts the first thing to happen is to retrieve the configuration from my central configuration file and populate their own configuration sheet. Once that's done, everything referred to in the script (named range) are effectively there for the script to be acted on. This way I can change my configuration at will on my central master configuration sheet, without bothering to send off a new script (a different configuration) every single time.