Copy Row in Excel to Specific Tabs

Hello,

I'm not very smart once I get outside of if-then formatting.

I have an excel worksheet. It is used to track purchases for different divisions of my company. A, B, C, D, E, F, 1, 2, 3, 4 are the divisions as they're identified on my master data page, titled FY 11

What I would like to happen is that any data entered into FY 11 that has the appropriate division listed in Column A would then populate over into the tab on the worksheet with corresponding identifier.

Example: Data entered into tab name "FY 11"
Cell A3 (the first line of data entry) has the entry "A". I would like excel to copy row 3 into row 3 of tab "A". (row 3 to allow me to input header information).

Thank you for your help, please let me know if I need to clarify anything.