I am trying to figure out how to input data into a master worksheet (sheet 1)
and have that data filtered into separate worksheets and keep newest data at
the top of other worksheets (sheets 2 and higher).

For example if I have 5 categories of information A,B,C,D,E and on worksheet
1 i input a new data for category A, I want that data to show up on worksheet
2 which is a compilation of all category A data inputs.

Is this possible with a formula?