2 issues. Between 2 sheets. cant remember the proper coding for using the If/End If state

So here's my issue.
I've been tasked with creating a macro for an accounting co. I have one portion completed that copies and pastes personal info from one sheet to another.
But the major issues I'm having is I need to take data from one sheet. (7 rows (A1-A7 and 3 Columns (A1-A3)) And what I need to do is copy and paste in specific row/column only.
Example:
Name | money | percent
Name2 | money |percent
Name3 | blank |blank
Name4 | money percent

I need to be able to copy all the data from Name, money and percent and paste into a seperate sheet plus add the letter "F" in this format:
Name| leave blank |money | leave blank | percent | F

and at the same time not include the Name3 with the 2 blanks because it doesn't contain data

the copy and paste features I have, but I can't remember how to write the If/end if statements using the VBA libraries. I haven't programmed since 2001 in college and a family member is in need of help.

Thank you for your support

So on "sheet2", I have 3 columns. Payment type, Assignee and percentage, What I'm trying to do is extract all 3 (Only if there
is data in the assignee and percentage column). If there is no data in those 2 rows, I need to pass over it
(or something like that).
Then I need to paste that information in the "sheet1" starting in the blank row below pay code with "Payment" in the
pay code section, "Assignee" in the Annual Amount section, Add "US" automatically in currency code, Add "F" in paycode type
and "percentage" and put that into the projection growth rate slot.

All while filling up each row kind of how it's stacked in "Sheet2"

I uploaded screen shots to help, I thank you for assistance on this

Here is the uploaded file of what I'm trying to achieve

You'll see that out of the 7 rows of data on "Sheet2", only 3 were entered on "sheet1" since the remainder of the data
was null in both assignee and inflation

Ok, here are the more up to date pictures if this helps. Info from both sheets and desired outcome

My mistake, I was taking screen shots instead. Here are the 2 quick work books.
1st is the information
2nd is how I'm looking for the outcome to be

Both sheets and their data are in exact location in reference to each other per row/columns

1. This will be a single woorkbook, 2 worksheets
2. There is not more than one instance
3. Yes, currency code and and F stay the same
4. Correct, Source will always be sheet2 and target sheet1

Awesome, I just got the code, will implement into the macro this evening, Thank you!

Thanks to Sintek, This thread has been SOLVED