Hi,

i am having 200 excel file in folder ..each file has many sheet...i need 1 sheet (that is one common tab from different excels )from all excels to copied in one excel in different sheets(1 excel sheet data should be copied 1 sheet and second excel data copied in second sheet and so on) not in same sheet. Need it urgent please respond . Thanks