Nii Nunoo
Procedure is basic same as You could do it manually.
Without needed details,
have You tried to record Your above mentioned step with Macro Recorder?
Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.