Native FileMaker tools only create brand new files when exporting to Excel so that will be your first problem. You should be able to set up a Macro in Excel (I've read of others that did this) that import data from a file generated by an export records action in FileMaker.
But automating described would be a challenge. Perhaps a Macro in Excel can open an HTML file that contains an FMP protocol to open a FileMaker file and run a script that exports the desired data? Even if possible, that assumes that your database is a hosted database.
@PhilModJunk Thank you for your reply.
The main hurtle is finding a way to have filemaker automatically export the desired data to a file (CSV, Excel, etc...) and from there I can easily pull the data I need onto my main spread sheet. So I guess a revised question, is there a way to automate an export from filemaker? It can happen once a day and that would be perfect.
Do it all the time. Perform a find and then export the found set. A file name and file path can be assigned to a $Path variable and used in the export step to name the file and specify a location.