Here is what I'm trying to do:

I have a workbook with multiple tabs, each containing a different property. Each spreadsheet con taints a large amount of apartment data. I need to be able to pull apartments with an availability date of "NOW" as well as an availability date of within 60 days (not sure how to input the date one in the criteria).

I created an advanced filter to pull those rows onto my "Availability" worksheet. All looks well except it will not auto update.

My understanding is that I need to write a Macro (new to this). This macro will need to populate a lost of currently available and soon to be available apartments from several different spreadsheets (within the same workbook) to a single list in one spreadsheet. And most importantly, it must auto update as new data is entered and as dates change.

I greatly appreciate any help.