I have 3 Google Sheet and want to combine all of them with:

- Sheet 1: 480 rows
- Sheet 2: 40 rows
- Sheet 3: 20 rows

The sheet keeps expanding by the day since the sheet's data comes from a Google Form

Currently I have the formula:

    ={IMPORTRANGE("Sheet 1 Link","Response!A2:M480");
      IMPORTRANGE("Sheet 2 Link","Response!A2:M40");
      IMPORTRANGE("Sheet 3 Link","Response!A2:M20")}

And I need to update the range of each sheet whenever there's new rows of data I need to manually update it into:

    ={IMPORTRANGE("Sheet 1 Link","Response!A2:M481");
      IMPORTRANGE("Sheet 2 Link","Response!A2:M42");
      IMPORTRANGE("Sheet 3 Link","Response!A2:M23")}

Is there any way to make the IMPORTRANGE's range dynamic depending on **Response** sheet's current row?