Data transfer from two different sheets based on drop down menu using a button

Good afternoon (my time),

I'm having an issue with a version of the attached template with sorting the data. I think my problem is in how I'm transferring the data over.

Right now I'm using a series of if/then statements, but I'd like to use the "sort" button on the "easy buttons" sheet to pull the information over from the "exceptions" and "log" sheets to the "Data for BD" sheet.

The information I need are (in order) columns C,E:M (starting on row 3), I need blanks to transfer over as a blank, and I need the data to transfer over only if "automated" is selected in column "A".

I have a frozen headings row in row 1 of the "Data for BD" sheet.

Thank you very, very much!