Excel 2007 : Pull data from multiple worksheets to one worksheet

[kristend]

Hello all -
I need some help which I'm hoping can be done without using a macro. I've attached my spreadsheet (I had to remove my business specific info) but I need some help bad. WHat I'm trying to do is use the front sheet period report for all jobs to pull all info from the next four sheets based on the period number I enter in cell D4. So for instance if I entered 1, I would want it to pull all the data from the four sheets where a 1 is in column B and I want the data to pull into the specific areas based on the job number.

Thank you for any help you can provide!

Kristen