I know that Amit's scripts are awesome! But you will need someone to adjust his scripts for your needs :-)
Hi there!
I have done a very similar job recently. You can check its review under the title "From Google Drive to Google Sheets with some conditions". In that project, the client had an Excel file uploaded to a Drive folder everyday. He wanted a Google Script that runs daily, read the data in the xls file and add only the new data to the master Google spreadsheet.
So for your script, we will have a time driven trigger that runs the script everyday, search the predefined Google Drive folder for xls files, opens every file, search the tabs that have the string "summary" in their names, read the data from these tabs and import the data into the master spreadsheet.
We can also adjust it so when there is a row in the master spreadsheet have the same fish name as a row that we are importing from the other sheets, we can adjust the script to remove the old row and replace it with the new one, or add both rows as you will specify :-)
The project will need 3 days to be completed!!
I know that I have few reviews here, but all of them are related to Google Apps Script projects! I have started my freelancing career on Upwork. I'm a top rated freelancer with a job success score of 99% there. I'm trying to build a good profile here as well!
I will be happy to address any of your questions!
Cheers,
Mohamed