hello
I search macro bring data from multiple closed workbooks in multiple sheets so I have file called search in cell b2 write the number based on col a in multiple closed workbooks into multiple sheets then show the result in file search col a the name file is existed data and col b,c,d as existed in files and the column e sheet name are existed in files