Copy data from row to a worksheet from multiple sheets based on Date

Hello all,

I am hoping somebody can assist me with this.

A very long time ago, "NBVC" on these forums gave an answer to a question that is almost exactly what I need. It is here from 7-17-2009:

Originally Posted by NBVC

See attached.

Add a column in the All sheet (Column N) and in N5 entered formula:

=IF(A5="","",IF(K5<=TODAY()+60,MAX($N$4:N4)+1,""))

which counts the number of matches (within 60 days of today)..

formula is copied down to row 100 to accomodate future additions.. you can copy down even further.

then in Renewals sheet...in A2, use formula:

=IF(ROWS($A$2:$A2)>MAX(All!N:N),"",ROWS($A$2:$A2)) copied down to count count of rows that will be extracted... copy down as far as you want..

in B2, use formula and copy down as far as you want and across all columns...

=IF($A2="","",INDEX(All!A:A,MATCH($A2,All!$N:$N,0)))

no need for button.. live update.

I almost have the exact type thing but I have multiple sheets with dates on that I need to have checked and then return the row of data to a main sheet for expiring.

Basically, I have the main sheet of "Expiring Licenses". This is the sheet that will collect the data from the other sheets based on expiring within the next 2 months from the current date. All the other sheets are individual office workers with licenses in different states that have expiration dates. I want to be able to have the main sheet just show me the people and particular license that is going to be expiring in the next 2 months and move the data over to the main sheet. I only need the data shown in the Expiring Licenses Sheet from the Name Sheets. Once, the name sheet gets updated when they renew their license, the Expiring Licenses sheet automatically changes with the update. Also, on the Name sheets, I want to be able to have cells "D" "E" they are Merged and pull the name from the Tab below. I thought I had it updating even if I changed the tab name but it doesn't. I just wanted to anytime I change the tab name, to change in the merged column. I don't have an issue un-merging the name column either. If you could please assist me with this, that would be amazing. Thanks very much.

I've attached a dummy file in case it will help.

Thanks in advance,

Chris