Hi, I am looking to know any macro or any farmula where it first sort the
data on one criteria and then copy the data from other Rows and columns of
the related Criteria to another sheet.

Kindly help me on the above