Is there a way to make google sheets import range function stick to the range when it changes in the source sheet?

Question

Context

So I have been using query and importRange to pull data from my other sheets in conjunction with importRange. This is because importRange did not get all the data from the spreadsheet. But it seems as though when I re-open the sheet, after leaving it for a day, the data in the new spreadsheet moves cells from where I placed them.

I have time-series data that have different dates and so the data is placed in different cells to each other relative to the dates. I have placed an example below:

So for instance in the second picture, the data for Softcat will move to a different cell location rather than where I imported it from. The same for Trainline (the third picture).

Problem

1. Is there a function I can use to prevent it from leaving these cells that I have attached them to? Especially for the ones at the lower end of the spreadsheet?
2. Should I move data in the source sheet (move around columns), is there a way to make importRange or some other means to stick with this column that has this specific data set? I tried fixing it with the '$' sign but it still displays different data from the listed column reference.

This is the sheet

question from:https://stackoverflow.com/questions/65557770/is-there-a-way-to-make-google-sheets-import-range-function-stick-to-the-range-wh

Answer 1

Waitting for answers