Filtering values from a sheet and returning them in a column on a different sheet

Is there a formula to filter values from a sheet and return them in a column on a different sheet?

I want returned on different sheets columns of filtered values from a particular table (on a different sheet). The sheets to which these columns of filtered values are going to be returned are already populated with lookup functions that are going to use the returned values

Basically, I need formulas on sheet sheets 1, 2, and 3 to populate them from sheet 0.

Any idea?

Hi Haseeb,

Here is and example of what I whish my file would look like.

In my actual file, there are more than 600 value that should be filtered onto 50 sheet which correspond to different groups.

I currently do the sorting by filtering the data on sheet zero with the data filtering tool and than copy paste the values onto each sheet. Hopefuly there is a less time consuming way to do this.

Thanks you very much,

Adam

Hi Haseeb,

works fantastic.. I was trying to go around producing the total count and an extra column for the row numbers, but this works perfectly.

Thanks