Split file with multiple sheets into new workbooks based on column value

[gamergirlxx1]

I have a file that contains three detail sheets and a pivot. I'd like to filter all three sheets based on column A and create a new workbook for each value in column A. The new workbooks would contain the three detail sheets and the pivot only containing data that has only data for one of the values of column A. I attached a sample file and what the ideal output would be. Thank you in advance!