Split specific columns into mutiple work sheets delimited by a column as well

[AJpearen]

Good afternoon,

I was searching the forms and thought I would find the input to my hurdle.

I am trying to extract records from a detailed worksheet into separate sheets but only specific columns.
I thought I might find a script for each of these two steps and merge the scripts together, but I have not been successfully to find such references I can use here.

I was able to find a script @ https://www.mrexcel.com/forum/excel...ta-into-multiple-worksheets-based-column.html to split data into multiple worksheets based on column, in additional I only want to bring over certain column's, and if possible select the order of them.

For context, I am pulling a list from SharePoint and then want to extract specific columns to separate worksheets based on a column value/delimiter.

Thanks for any input and insight anyone may have