Need help creating macro to move cells from same row to diff. Sheet based on value of cell

hello all,

i am fairly new to excel and i am struggling to find a solution to the following problem: i have this spreadsheet that keeps track of all of our machines in inventory and the machines are listed by an inventory number. the machines are sold by 7 different sales reps. what i need is to create a formula/macro/magic spell that will sort each sales rep. (column AJ) into a separate sheet and include the data from the row that the sales rep name appears on and the data found in the columns that i will specify below.

columns: A:D, I, M:N, Q, AC:AF, AI:AK

i also want it to update if i make any changes to the master spreadsheet.

do i have to have sales rep sheets in the same workbook as the master sheet or can i put them together in their own workbook?

i have attached a copy of my spreadsheet.

thank you so much for your help in advance and i apologize if i have posted this question in the wrong section.