thanks in advance for answering this problem..
now come to problem
i have to consolidate excel worbooks in one new master excel worksheet (in one worksheet)
my range is from A6:BG and upto the last
and all excel file is located in te same folder so please help me to consolidate all the data
this work is to lenthy to go through manually
so i think macro is good substitute for it