I am trying to figure out a way to automatically prepare a mail merge table using a macro. I have an excel worksheet with 25 tabs. Each of these tabs is formatted identically. One of the columns is 'Deadline for Paperwork'. I would like to write a macro that takes any of the rows of information where this date is between =TODAY()-5 and =TODAY()+2 and displays them in a table on a separate sheet (named summary).

I will then use this table to create a mail merge to product the required paperwork.

Thanks for your help in advance