Create multiple pivot tables/files with loops

Hello Everyone, I am absolutely a newbie to VBA programming.
I have attached a file that contains three tabs. 1). source Data to which the pivots will use. 2). a pivot table. 3). a list of pivot Filters (Clients).
I have started some code, but I'm sure there is a better way to accomplish my objective. And currently, I'm not getting a good result.
What I'm trying to accomplish?
Using the source data to create a file for each client listed on the "clients" tab with a pivot table showing that clients detail using a filter.
Also, how do I change the data in the pivot to "Sum" instead of "count"?
Thanks in advance.