Formula to copy rows by category but keep continuous row numbers (1,2,3...) instead of original row IDs?

Hey everyone,

I need some Excel advice. I have a Master Sheet (Sheet 1) where I log entries and assign them a category (e.g., Fruit, Vegetable, Meat).

I want to create separate sheets for each category (Sheet 2 for Fruits, Sheet 3 for Vegetables, etc.).

I know I could just use the standard built-in filter on the Master Sheet, but that is exactly what I want to avoid. If I filter for "Vegetable" on the Master Sheet, Excel just hides the other rows, so the visible row numbers look like 5, 32, 85... Instead, I need a formula for the "Vegetables" sheet that automatically pulls the data from the Master Sheet, but stacks the rows perfectly from the top down, so that the row numbers in the new sheet read continuously as 1, 2, 3, 4, 5... without any gaps or keeping the original row coordinates.

What is the best, dynamic formula to achieve this in modern Excel?

Thanks!