So I am pulling data from a webpage on one tab and I am Index matching on another tab to get data from the table it is generating. I have the tab refreshing every 3 minutes to keep the data fresh. Everything is fine all day, however, when I close the sheet and open it back up in the morning my Index is completely wrong. For example my formula is
Formula: copy to clipboard 
=IFERROR(INDEX('Do Not Touch'!$C:$C,MATCH(Outbound!B2,'Do Not Touch'!$A:$A,0))," ")
however when I open it up in the morning it may look like this
Formula: copy to clipboard 
=IFERROR(INDEX('Do Not Touch'!$BZ:$BZ,MATCH(Outbound!B2,'Do Not Touch'!$A:$A,0))," ")