VBA help!

Hello,
I am absolutely a novice when it comes to macros and VBA and need some help.

I have a workbook with 6 worksheets. The first work sheet ("All Grants FY15") has 5 columns ("Date", "Grant", "Type", "Amount" and "Category", A2:E2). I am using this worksheet to enter all grant expenses. The remaining worksheets ("City ESG", "County ESG", "CoC HMIS", "SSVF HMIS", and "HMIS Program Fees") have the same columns at the same placement. In each of these subsequent worksheets, I have the name of the grant (which matches the value that will be placed on "All Grants FY15", B2:B500) placed at F2.

I am looking for a way to loop through "All Grants FY15", read the value at B2:B500, and copy that row into the next blank row on the corresponding worksheet where F2 on that worksheet equals B2 on the "All Grants FY15".

Does that make sense?
A