Hello,
I need to create a worksheet called "Current Rent Roll" that is linked to individual lease worksheets within the same workbook. The new worksheet needs to pull a value from a range in the other worksheet based on the date in another range of that same worksheet. In other words, Current Rent Roll would pull the lease amount from each worksheet based on the date (Februay 1 - 29, 2012).

I would need to see a sample workbook with a fully mocked up ROLL SHEET showing your full desired results, and a few "individual lease worksheets" from which those sample results were derived.

Mock that up (replace sensitive info with something generic for the sample) and post here.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.