Create a new Excel file based on data in column


I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadsheet with departmental data that needs separated by managers name, so it may be distributed to each with only their teams data. Essentially, I need a file for each manager and it to include the corresponding data. The managers name is in column "F". For this week, I have 57 rows of data and columns range from A to I. Is there a macro or a code to use in VBE that I can run to do this automatically? I know I can use sort & filter to copy and paste the data into each additional file but I'm hoping for a macro that will be able to take care of this.