Pull Data Based On Dates

You know, I thought about that after I left. How are you guys supposed to edit a screenshot. That made no sense, so I apologize on that part.

FDibbins, I'm not entirely sure I understand what you mean as far as having multiple spreadsheets. How do you suggest I lay it out? I'm completely open to suggestions. I'm sure there is a much better way to lay it out than how I have it.

So right now, I have the following workbooks...

V-Building 151
V-Building 153
V-Building 155
V-Building 159
V-Building 161
V-Building 163
V-Building 167

And then I have another set of 9, for our other property. We have two properties that we manage here, one has 7 buildings, the other has 9. All the sheets should look identical, with the exception of room numbers and things like that.

Anyways, attached is the V-Building 151 sheet. If you wouldn't mind, check it out and see what suggestions you have. The ultimate goal is to have a way to pull the X,C,I results based on a selected date range. If that makes any sense...

I appreciate you guys taking the time to help me with this. You're awesome.

Sorry to be the guy to bump a thread, I know that's a no no, but I really need help with this as soon as possible. I'm kind of stuck on what to do with it..