Replace contents of named data table without breaking references

Using Excel 2007.

I have a worksheet called "RawData" that contains about 10 columns and 45K rows of data. It's formatted as a data table (Insert > Table) and I named it tblMyData. A lot of formulas in the workbook refer to this data using structured references (e.g., ... INDEX(tblMyData[Region] ...).

I will need to regularly replace the contents of tblMyData. The columns will always be the same but the rows will vary.

What is the best way to do this?

Should I select all the data in tblMyData > hit delete > and then copy and paste the new data?

Should I put the new data in a separate workbook, and link the cells in tblMyData to that workbook?

I'd like to automate the process as much as possible.

Thank you for suggestions.

Originally Posted by Tinbendr

Could you?
Click table->Design->Convert Table to Range.
Home->Format as table (Styles)
Formulas->Define name. Table1
Change fixed range to dynamic. Search for Dynamic Named ranges. There's hundreds of examples.

A data table already supports a dynamic range, so I don't see what converting it to a dynamic range would do for me (other than make me change all my formulas from using structured references).

Also, if did this, I'd still have the same question: What's the best way to replace the data with new data, from the standpoint of automation? Delete, copy, & paste? Linked workbook?