Uploading Large Sheets In As Data Dumps


We are working on a project where we create data dumps in a folder that many sheets can use as a resource through formulas. Is there any way to upload daily under the same name, overwrite the file and not break the formulas that are pointing to these sheets?

What are some solutions around this? Will we need Smartsheet Data Uploader? Or can this be done without.

We have been treating these sheets as "import sheets" trying to get around the 500 line limit. But is there another workaround to this issue?