require formula help to copy data from sheet to sheet

[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.