consolidate data from multiple workbooks in excel | vba |with code

hi i am Manoj Kumarin this video we are going to learn to consolidate data from multiple sheets in excel

code link

consolidate data in excel
excel consolidate data
consolidate in excel
how to consolidate data in excel
consolidate function in excel
excel
excel consolidate data from sheets
combine data in excel
how to use the consolidate function in excel
microsoft excel
excel consolidate
how to consolidate in excel
data consolidate in excel
consolidate excel
consolidate
data consolidation in excel
how to consolidate data in excel from multiple worksheets
consolidate data from multiple workbooks
consolidate data from multiple worksheets in a single worksheet vba
vba to consolidate data from multiple workbooks
combine data from multiple sheets
consolidate multiple sheets in excel
consolidate data from multiple sheets in excel
macro to consolidate data from multiple workbooks
vba to combine data from multiple workbooks
excel vba
vba to transfer data from multiple workbooks
transfer data from multiple excel workbooks
vba
vba copy data from one workbook to another
consolidate multiple excel workbooks
excel vba copy from one workbook and paste into another
vba tutorial
vba macro to copy data from another workbook in excel

from
bhorha
simri bakhtiyarpur
saharsa
bihar
india

[achuk]

Sir, the second step is not working for me, i have changed the file name as 1, 2 3 etc. In the beginning.. is it due to rename? Please guide