sort order according to columns specific in another worksheet cells

hello friends ,

i am trying to sort four columns in sheet("sort")
order to be sorted changes , depending upon my need .
order to be sorted is been specified in sheet("order") A2 B2 C2 D2 cells

depending on need ,
order in which i want this 4 columns to be sorted , can be enter in A2 B2 C2 D2 cells
for exampe1 :
i want to sort first column4 then column3 then column2 then column1

for example2:
i want to sort first column1 then column2 then column3 then column4

basic need for this vba , is to sort according to my need , so i just have to input column number in cells .
for understanding i have attach sample file . thank you

Hi! I am not sure if I understand your question. What is the difference between sorting in a different order, if in the end the four columns will be sorted independently? I am sorry If I did not get your point...

Hi! I think this works...

Great!

If the answer helped you, please consider to add some reputation by clicking the Little star below this post. Thanks!