Copying data fromm different excels into one new sheet by cond

Closed
Report
-
Hello,

I have 2-3 different excel sheets. by specifying the criteria ie if the category:ABCD then copy all the data pertaining to match should be copied into new excel sheet.