Filter data that changes everyday to a new excel workbook

Hello,

So is have a backlog file with vendors that needs to be filtered one by one vendor, pastate each line with specific vendor data to new excel workbook and save it in folder.

The problem is, i do not know how to clarify filter criteria, as the vendors in excel changes every day.

Should i make it with if criteria including every vendor?

Thank you in advance.