I need to auto update a master tracker with the information updated in two different google sheets updated on daily basis.

1. Master tracker where the data should be updated automatically (Team Aegon – Master Sales Dump) when other sheet get updated based on the date

docs.google.com/spreadsheets/d/13lGFhZmn5A6k1KazDvqsD8CNkv-Cu4sWkoDJKZT0EH8/edit#gid=1672705473

• From coloumn “A” to “P” followed by every next entry row wise based on today’s date in column “G”

2. Sales Team tracker 1 – Team Anil Revenue Tracker – sheet From where the data should be pulled

docs.google.com/spreadsheets/d/1DFMaVVUerBB2eXxyfm9fheM25n3-gJ3HH8AZE-9mqjE/edit#gid=386541069

• Data to be pulled from Coloumn “H” to “X” based on todays date mentioned on coloumn “O”

3. Sales Team Tracker 2 – Team Shabna Revenue Tracker – sheet From where the data should be pulled

docs.google.com/spreadsheets/d/1JsTmtwcb20ozUES5QDlpMOTMZqXmOfWw-75lZ5xKT1E/edit#gid=1598556396

• Data to be pulled from Coloumn “I” to “X” based on todays date mentioned on coloumn “O”

The sheet name for both sales team trackers from where data is to be pulled is “7 May 2024 – 20 May 2024” – this sheet name gets changed every bi-weekly to the next bi-weekly dates (Exp – Current bi-weekly sheet name is “7 May 2024 – 20 May 2024″ next will be “21 May 2024 – 03 June 2024”) This can be edited by weekly manually so not a big deal but if possible need to find the new sheet and update

Data in the sales tracker will be updated daily from 11 AM IST to 8 PM IST

I need as and when data is entered in the sales team tracker it should automatically get updated in the master sales dump. daily basis

Your help will be much appreciated and thanks in advance for your support

Regards,
Mahesh

I tried

IMPORTRANGE(“1LW3CY98ARucastVNf2L_zHpzgIAwKTZaSRnWl-vnky4/edit#gid=186936441″,”H2:W”),”where Col1 is not null offset”&COUNTA(IFERROR(IMPORTRANGE(“10cAId6WXHVByrKnxA6ydIHBoIQbQFMDoU3q0fq68diA/edit#gid=1339901331″,”H2:W”)))-1))

But this only gives me data from one sheet.

So I need a macro code or query/formula to pull data from both the sheets to the master sheet based on date and real time (if possible). sheets are updated as and when sales is closed and the sheets are operated by two team sitting in different offices so no overlapping required.