Copy Data Range to another sheet based on a condition.

Ok so I am a new member to this forum and I have been reading post after post regarding macros and formulas and I am not getting anywhere.

Here is the problem:

I'm sure you all have heard about the medicare penalties regarding hospital readmissions. I have a spread sheet that we log patients into if they have been readmitted to our facility in less then 30 days since their previous discharge. I know that this would be better suited in access but I only have excell to work with d/t departmental butget. Our departmenet has 14 case managers and we are all entering data into this sheet.

What i need is:
1) A way to make all enteries in caps whether it is entered in caps or upper and lower
2) Based on the colum CHF readmssion (yes/no) = the answer yes, I need the colums from sheet 1: "r,q,c,d,f,g,h" of that patient copied
to sheet 2 for a follow-up call once a d/c date in collum R is entered in sheet 1. of course this data will need pasted in the next
available row on sheet 2 from sheet 1.

The problem that i have now is i am using a copy and past formula based on a yes value in the chf readmssion collum, but this does not allow me to sort data an is also leaving lines inbetween data sets. This is hard for everyone to work with.
I will attach a blank copy of my sheet hopfully somebody can help me.

Thanks
Mike