Copying Rows from a spreadsheet to a new spreadsheet if text appears

I have a master data sheet and I want to copy rows from the master to a number of different spreadsheets depending on the value picked in one of the cells from a dropdown list. For example I have 8 columns of data and in column 4 the #'s 1,2,3,4 can be chosen from a drop down list. If 1 is chosen I want to copy that entire row to sheet #2 and place below the existing headings in the next open row. If 2 is chosen than the whole row should be copied to sheet#3 and so on through 4.????????

Hi,

Can you post a sample of your file?

Elio Fernandes