I have one Google sheet having three tabs, Sheet 1, Sheet 2, Sheet 3. I have another tab having the name "Sheet 4" in which I want to import all data from these three tabs, but the problem is data in these three tabs will keep on updating, that is dynamic.
={QUERY(IMPORTRANGE("1Cqf7ozYcrTb99X4-x1vzHcrs4pqXTBcNqLtaSZnihjE","sheet 1!A2:Q"),"SELECT *",1);
QUERY(IMPORTRANGE("1Cqf7ozYcrTb99X4-x1vzHcrs4pqXTBcNqLtaSZnihjE","sheet 2!A2:Q"),"SELECT *",1)}
The result which I am getting is data from Sheet 1 is coming but data from sheet 2 is not coming.
Can anyone please help me how can I import data from all required tabs