VBA to turn a table into a data connection

[happyhungarian]

Is there a way to automatically turn a table into a connection based upon the value of a cell? Let me explain. Let's say I have a table called "Employees", i would want to be able to type "employees" into cell A1, run this code, and it would recognize that based upon what I typed into cell A1 that I want to turn a table called "Employees" into a data connection.

I had this question under a different thread but i felt it made sense that it should be on its own since it wasn't necessarily linked to original purpose of the thread.