VB Required For Dynamic List

I have a table in a workbook with names in the left column and top row. The intersecting data fill the rows under and to the right of these named areas. I need to keep this table in its own workbook, because many sheets in other workbooks will access its info. I have linked this workbook information to a sheet in each of my accessing workbook. I call this sheet "DataLink" and it is a sheet that uses an If(Original Data Ref Cell="","",Original Data Ref Cell). This works well at bring the data into my active workbook.

My active sheet has 2 drop down lists. One for the top row of names on the DataLink Sheet, and one for the left column. I have used the Offset Function refering to cells with the countif and count functions in my Data Validation setup to make the addition of the names in the DataLink Sheet Dynamic. This also is working well.

In my Taget cell (CeIl where I will get my answers) I use the Indirect(row) indirect(column) to retrieve my intersecting data relate the the row and column. This works well as long as I establish my defined names of each column and row with Ctrl-Shift-F3 and choose (Top and Left)

Now my problem. Although I can dynamically add the names to my drop down list I cannot retrieve the data from new entries on my DataLink Sheet(remember coming into active workbook from outside source) unless each time I return to my DataLink Sheet,and highlight the entire range of cells and do a new Ctrl-Shift-F3, which then ask me if I want to replace each name one by one. I have some 700 names defined. And this is disconcerting to say the least. Is there a way to add code to automatically add the contents of a cell as a defined name. This way as my information from my original data workbook enters the DataLink Sheet in each of my Active workbooks, new names that appear in the left column and top row will be defined as have intersecting data under them.