Auto Populating Individual Worksheets based on Main Worksheet

I have an excel file that has 5 sheets. (Main, 1, 2, 3 and 4). In the main sheet I have data lined up per row, in each row, column A has a number 1, 2, 3 or 4. I want to be able to add a line to sheet Main and then have that line also added to the respective sheet depending on the number entered into column A. (ie if a row is added to 'Main' that has a 2 in column A then that line automatically shows in sheet '2').

Any help or guidance would be appreciated!

After doing some more research, an auto filler did work for me. Unfortunately the redundancy was necessary. For any who are interested in the future, this is what worked for me:

Please Login or Register  to view this content.

That code was placed in A1 of every sheet, just changing the =1 to whatever number I wanted to be shown from F1 (where the data was I wanted to sort by). I then copied that cell to the entire sheet and then sorted the data.