Yes, a bit more clarification.
for 1. What cell  do you want to put "F" in? A specific column or anywhere
column A-T.
2. "Final Spreadsheet" ?? Are you copying to another sheet or are you talking
about this one?
3. Once #2 is complete, there is no "F" in the row! so shouldn't you test if
there is not "Alert"?
4. sort: easy...
So.. is this interactive? Meaning, are you making changes and wish for it to
update, or are
you loading from another source?