Saving of data into separate file using different choice and into different folder

Dear All Experts here,

I am thinking of automating the inventory reporting process and has the following needs:

Inventory report consists of 1xx,xxx lines and I do not require to save all customers into separate files. Can I use a worksheet (I named it Request) to input the things that I wanted to save into?

In the worksheet "Request", instead of using a different macro for each different Column, can I just use 1 marco and do all the job as per my sample?

What we are doing now is, we will first sort this whole list of data and make it into a table and select only 1 of them out, copy the chuck of data into a new workbook and save it. Then filter another account and repeat the same process.

Thanks a lot.