Hello, I have a workbook with several worksheets for different properties. I need to create a worksheet to extract the current month's lease payment from each property's worksheet based on a date range. So if it is February, 2012, the new worksheet would show the amount of the lease payment due for that month.

Um... a little more detail, or example, I think would solve this... but from what I can see right now, a Pivot Table would be handy.