Split tables

How can I split a huge table into separate workbooks by Salesperson, but keep the formulas & formatting?
Pivot table won't work because it changes the format of my master worksheet.
Tried a macro I found online and Ablebits Split table tool, but neither copies the formulas.
Right now, I'm filtering and then copy paste. blek