Unreliable Data Source


Long time listener, first time poster. I have a dataset sheet ("Sales Data") that I only have Viewer access only. The owner of the sheet isn't open to modifying anything so I have to create a solution.

Task: Pull information from this sheet (using 'Index/Collect) into "Timeline Sheet"

Primary question/issue: Rows in the Sale Data sheet are deleted once certain milestones are achieved so using Index/Collect will lead to errors in the Timeline Sheet.

Is there some way I could extract Sales Data rows to Timeline Sheet with a formula without the formula breaking as rows are deleted in Sales Data.

Any help is appreciated!