I have a Workbook with many tabs for Lease Properties. I need to add a Worksheet for the current month's Rent Roll. The formula for each property's current month rent needs to refer to that property's worksheet. It would need to extract the value for the rent based on a date range in that same property's worksheet. Can anyone help?