I have been struggling with this problem.

I have a 4 sheet workbook going, sheet 1 contains four colums; Name, Address, phone, and priority (A,B,C). Sheets 2, 3 and 4 have the same four colums, but I would like excel to automatically popluate those colums based on the results of the priority column from sheet 1. The end result would be a workbook where I can enter all data into sheet 1, sheet 2 would fill with priority A data, sheet 3 with priority B data and so forth.

Thanks...