Excel 2007 : Need help linking using logic formulas

So if I have numbers or words in Sheet 1 (being used as the main database). example

5 55632 dodge micheal susan 1999 Feb
9 99636 Ford rick steven 2005 November

lets say all the other worksheets in the workbook are named January(sheet 2), Feb(sheet 3), Mar(sheet 4), and so on. So if I enter the information like in the example and then enter Feb in the last cell. How can I get the forumla or code to link the prior row of cells into Feb(sheet 3) only. Maybe this will clarify what I need help with.