excel with indirect matching across worksheets

I am a relative newbie so please be kind.

I am having trouble trying to get the formula correct to retrieve the market sales for Mrs Renfros salsa from the worksheet called Albany. I want it to be placed in cell C6 in the Master worksheet.

I was able to corretcly use the indirect function to pull the total regional dollar sales, but am having trouble combining it with the match function so that it find the appropriate row to retrieve the data from Column 6.

Please help - work related and I need to get it done soon!!