Excel Macro to consolidate 10 excel files in 1

I have 10 excel sheets that I need to generate wchich has fixed columns from A4 to AO4 but with different row numbers.
All excel sheets will have additional text after the rows with data, please see reference A2523.
Row A1 to A3 will have a text as well.

Is it possible to run a macro wherein I would just need to browse the files that i need to consolidate instead of opening the 10 files and manually pasting it in one template?

Here's a macro I used for a similar function a while back. You should be able to modify this to pull the data from each individual excel file and consolidate it all into one.

Please Login or Register  to view this content.

hi, i do i run this after pasting the code to the module? i am only getting, "No files found" message. please help. thanks!