Needing help with a dynamic formula

Hi,
I am needing some help building a formula using a separate data source. For each profit center in column A there are 14 rows of data, but the profit center # is only listed on the first row. Then each column beginning with D is the monthly data. I need to look up the profit center and give me the 2019 forecast for each month which would be in row #6 and then beginning with column #3. Please see the attached file for a sample layout of the data source. (NOTE: I cannot copy down the profit center # because this file is updated almost daily from our sales managers & I have to pull it down from our corp site weekly).

I have used the below formula and it works PERFECTLY, except for when I close the data source file.
=OFFSET(INDEX('[2019 Natl Accts Forecast.xlsx]Dollar General'!$D:$D,MATCH($E8,'[2019 Natl Accts Forecast.xlsx]Dollar General'!$A:$A,0)),6,4,1,1)*1000

Once I close the file I then get #Values. I realize it's because I'm using OFFSET.

So I then changed to the below formula, but it only gives me the data on the row where the profit center # is and doesn't march down 6 rows.
=INDEX('[2019 Natl Accts Forecast.xlsx]TOTAL MAY'!$A$3:$O$602,MATCH(E7,'[2019 Natl Accts Forecast.xlsx]TOTAL MAY'!$A$3:$A$602,0),MATCH(S7,'[2019 Natl Accts Forecast.xlsx]TOTAL MAY'!$A$3:$O$3,0))*1000

What options do I have to tell the formula to get the exact cell of data I need?

Thank you for your help!

Thanks for the quick reply. Are you adding the +6 to the 2nd formula? If so, I just tried that and Excel says I have too many arguments.

That worked!!!

However, you'll notice I have the 2nd Match looking up S7 which is a cheater column I created for the months and I really don't want that cheater column in my report file.

The 1st formula worked exactly how it should have without a cheater column, but because it uses OFFSET the data goes to #Values when I close the data source. Is there a way to fix either formula or is my best bet to use the 2nd one and create a cheater column for the months?

I hope that all makes sense.

In my report file where the formula is housed, I had to create a column that has the months in it. That's what the 2nd Match S7 (MATCH(S7,'[2019 Natl Accts Forecast.xlsx]TOTAL MAY'!$A$3:$O$3,0))*1000) is looking at in order to find the proper month in the data source. I'm sorry for the confusion, it's hard to describe. I'd like to do away with that "extra" column, but I don't think it's possible.

Thank you so much for your help on this.