How to display information based on date?

I have a workbook that contains several different sheets that track the daily number of jobs and sales from each of my company's branch offices. What I am using right now to get everything into the main summary worksheet is a bunch of nested if-then statements. (See attached file for the horror. "Formulas" page. Can't miss it.)

Can anyone offer a simpler solution? Basically, what I need is for the numbers for a given date (entered on the "Install Progress" page, cell C1) to be displayed in their respective spots on the "Install Progress" page.

Granted, what I am using works, but it is just ugly and, if I need to move something or add a page, a real pain to adjust.

Nothing that involves VBscript. This sheet is distributed to a mailing list of managers and I don't want to have to explain why Excel keeps asking them to allow macros.

use a look up
i used index match(just because i prefer it)
see attached
couldn't put it on yours coz it was protected

formulas in J K AND L 10
only did jacksonville as example

Thank you for your help, Martin. I apologize for the file being locked. I actually unlocked it before I sent it. I suppose I attached the wrong file. Sorry about that.