Create a Macro (Box) in excel where I would like to apply multiple filters; each filter condition results should populate in different sheets with updated sheet name in it. Would like to hear the solution.

Requirements on HighLevel:
Sheet 1 - Create one macro button and give some instruction
Sheet 2 - Source Data
After clicking Macro button; it should generate three sheets with the specified name and results should be populated accordingly

Create a Macro (Box) in excel where I would like to apply multiple filters; each filter condition results should populate in different sheets with updated sheet name in it. Would like to hear the solution.

1st Filter Condition:

Loan Store Type
Texas Check
Texas DLA Check
Texas REA Check
Texas VIP Check

Result of the above filter condition should saved in CLT-Check Sheet in same excel

2nd Filter Condition:

Loan Store Type
Texas Debit/Credit Card
Texas DLA Debit/Credit Card
Texas REA Debit/Credit Card
Texas VIP Debit/Credit Card

Result of the above filter condition should saved in CLT-Debit Credit Card Sheet in same excel

3rd Filter Condition:

Loan Store Type
Texas eCheck
Texas DLA eCheck
Texas REA eCheck
Texas VIP eCheck

Result of the above filter condition should saved in CLT-eCheck Sheet in same excel