So here's what I have so far. I have a reference that looks like this:

Please Login or Register  to view this content.
It pulls a sales number from a different workbook and works just fine, but my boss likes the sheet I created and would like to use it for the district. This cell reference appears multiple times in the sheet and for other locations to use it, each user would have to go in and change their location number (XXX) and the month they are working with within each reference.

What I'd like to do is build a sort of "setup" worksheet within the workbook where the user could enter their location number and month and the above reference would automatically update itself. I've done a bit of research trying to figure it out and I've come across the INDIRECT function, but the other workbook is closed and I'm not exactly sure how to parse the entire reference. Can anyone point me in the right direction?