Pick and move certain cells to a new sheet when cell is auto formatted with red text(macro

I have two worksheets.
The first one is a master list (table) (rows of data consisting of 7 columns-customer name, product type, required date, etc.) I have auto-filter turned on and turns the "required date's" cell color to light red and text to dark red, if the required date falls within a time frame of "today's date".
The second sheet is a table that I want to display info from the first sheet on if the cell color and text is red (as explained from sheet one).
I only want to copy and move data from the first, second, and sixth column of the rows that have the "red" formatting happening.

My goal is to have the second sheet auto cleared and auto filled every morning and auto sent via outlook email to a contacts list that i am creating.

This workbook is kept on a sharepoint server.

Please help.

I can send a copy of my workbook if necessary.

Thank you for looking.

Jake

My workbook is 1.27MB. It won't let me upload. Do you have any suggestions?

Because of the nature of the data that I use, I have changed and erased certain table information. My workbook still runs the way I want (at least up to the point that I have it) I am currently stuck in a couple of areas.

What I want is to fill out the userform (SECOND MEMBER DCS), and have it save data to the "Master List" as well as fill out a chart on another sheet which is sent as pdf via outlook.
When my "master list" notices that I am overdue waiting on a form to be returned (hence the "required date" column cell turning light red with dark red text) it will then send information from that row to my "Past Due" sheet table.
It is the "Past Due" table that I want to be updated automatically every morning and emailed to my outlook list that I will create.

Thanks again for looking.

Jake

I have decided to go at this with a different approach. Please let me know if I should delete my post or just leave it up.

Thanks.

Jake