Pulling information into another Worksheet

[colbyjack]

Hi
I'm hoping someone can help, i have one large spreadsheet and need to pull some information over into individual worksheets, i.e if the prefix in column A is 1 i need all the infromation pulling over, if the prefix in column A is 2 i need that to go into another worksheet

i have attached a copy of the spreadsheet if this makes sense

thanks