require formula help to copy data from sheet to sheet

[Terry]

I need a little help. I have a spreadsheet that has lots of data that gets updated weekly.
Currently i filter the data and copy the parts i want, to other worksheets, however this is very time consuming. I do have some restrictions due to the fact that i work on a government system. I need to use formulas no VB.A Can you help me?

I have a simple example
the worksheet has different types of animals with size, type, color and tabs that match the animals. I need the entire row(S) to be copied
can you help me create a formula that sorts the animals in column A and then copies the sorted ROWS to the tabs that match

[Charles]

Terry,

Welcome to the forum.
I'm not a "Formula" person. But I know it can be done with code.
Perhaps another member with Formula knowledge can address this to you.
It may help if you can attach a redacted copy of the workbook so we get get a better ideal as to help you.

[LalitPandey87]

I don't think if there is any way to filter data using formula only. Can do easily with the help of macro.