Master Google Sheet (Leads Master Database)

1. Management Database 2

2. Management Database 1

3. Customer Service 1

4. Customer Service 2

5. Customer Service 3

6. Customer Service 4

7. Individual Sites Databases (There are a total of 25)

7.1. Site 1

7.2. Site 2

7.3. Site 3

7.4. Site 4

7.5. Site 5

7.6. Site 6

7.7. Site 7

7.8. Site 8

7.9. Site 9

7.10. Site 10

7.11. Site 11

7.12. Site 12

7.13. Site 13

7.14. Site 14

7.15. Site 15

7.16. Site 17

7.17. Site 18

7.18. Site 19

7.19. Site 20

7.20. Site 21

7.21. Site 22

7.22. Site 23

7.23. Site 24

7.24. Site 25

8. Using filtered FUNCTION =query(importrange("SpreadsheetID for each site","A2:Z"), "Select * where Col1 is not null ")

9. Using filtered FUNCTION =query(importrange("SpreadsheetID for each Customer Service Spreadsheet","A2:Z"), "Select * where Col1 is not null ")

10. Using filtered FUNCTION =query(importrange("SpreadsheetID","A2:Y"), "select * where Col10 contains 'SiteID'")

11. Using filtered FUNCTION =query(importrange("SpreadsheetID","A2:Q"), "select * where Col10 contains 'Site1' or Col10 contains 'Site2' or Col10 contains 'Site3' or Col10 contains 'Site4' or Col10 contains 'Site5' or Col10 contains 'Site6'")