VB Script to Automate Creation of Excel Files from data in one File.

There is one big Excel file with client time reports tickets.

The client ID is in Column S [Project Key].

A client can have a number of tickets/ which are displayed in rows.

I need a VB script to be used in an Excel Macro which can look up all the Client tickets by Client id [Project Key], and then create individual CSV/ excel files and place them into a folder.

There are currently 120 Clients and will be thousands of tickets.

Attached is sample CSV file and some sample script which creates the files, but only creates files every 35 rows (this does not sort by [Project Key] which does quiet fit the purpose needed as a client can have more or less than 35 rows.