How can I copy entire row to another sheet based on cell value

[Moon210l]

Hi i looking to see how i can copy entire row base on the base on referral status to a new worksheet

CSC

Credible #

FIRST NAME

LAST NAME

CASE NUMBER

VENDOR

PROGRAM START DATE

INTRODUCTION OUTREACH

REFERRAL APPOITMENT REMINDER

FOLLOW UP

NEXT OUTREACH DATE

Not Responsive Outreached Count

PINNCH REFERAL

ALTERNATIVE ENGAGEMENT

PINNCH OR ALTERNATIVE ENGEMENT FOLLOW UP DATE

CAREER INTEREST

PHONE NUMBER

NOTES

Referral Status

Angela

3

ANGELIQUE

REYES

12354

America Works Site A

7/3/2024

YES

YES

Active

 

[My Aswer Is This]

I think we would need a lot more specific information.
Like:
What column is referral status?
Say something like column 6 or column 8

And what is the name of the copy from sheet and what is the name of the copy too sheet?

And you said:

based on cell value​

What must the cell value be?

And you said:
to a new worksheet
So, the script each time it is run must create a new sheet?