Macro for special copy and paste

[laravindh]

Please provide me a VBA code that will run and do the below task automatically. I would be grateful if you provide me a solution.
I am having around 100 to 150 excel files having different file names.
I mentioned the exact requirement in Steps:
Step:1 Sample 100 files are listed here but this names also will vary for each project.

247001.xls	247021.xls	247041.xls	247061.xls	247081.xls
247002.xls	247022.xls	247042.xls	247062.xls	247082.xls
247003.xls	247023.xls	247043.xls	247063.xls	247083.xls
247004.xls	247024.xls	247044.xls	247064.xls	247084.xls
247005.xls	247025.xls	247045.xls	247065.xls	247085.xls
247006.xls	247026.xls	247046.xls	247066.xls	247086.xls
247007.xls	247027.xls	247047.xls	247067.xls	247087.xls
247008.xls	247028.xls	247048.xls	247068.xls	247088.xls
247009.xls	247029.xls	247049.xls	247069.xls	247089.xls
247010.xls	247030.xls	247050.xls	247070.xls	247090.xls
247011.xls	247031.xls	247051.xls	247071.xls	247091.xls
247012.xls	247032.xls	247052.xls	247072.xls	247092.xls
247013.xls	247033.xls	247053.xls	247073.xls	247093.xls
247014.xls	247034.xls	247054.xls	247074.xls	247094.xls
247015.xls	247035.xls	247055.xls	247075.xls	247095.xls
247016.xls	247036.xls	247056.xls	247076.xls	247096.xls
247017.xls	247037.xls	247057.xls	247077.xls	247097.xls
247018.xls	247038.xls	247058.xls	247078.xls	247098.xls
247019.xls	247039.xls	247059.xls	247079.xls	247099.xls
247020.xls	247040.xls	247060.xls	247080.xls	247100.xls

<tbody>
</tbody>

All above Excel files have a common column name as highlighted in below snap. I need to copy that columns “TITLE 1, TITLE 2, TITLE 3, LOCATION” , “DRAWING” and “SHEET, NO OF TOTEL SHEET”

Step 2: I need to paste the copied columns into another master file with name “MASTER” in the format as shown in below snaps.

​

Step 3: This process continuesfor all the files one after the another continuously

(Ref:Fig:1).​

. Please refer below.
Butthe drawing priority for the copy and paste to be followed from another excel(Ref:Fig:2).
Fig 1: Copy paste one after another

​

<strike></strike>


Fig :2 Priority Follow excel

​

<strike style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(0, 0, 0); font-family: Calibri; font-size: 16px; font-size-adjust: none; font-stretch: 100%; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"></strike><strike></strike>

<strike></strike><strike></strike>

<strike></strike><strike></strike>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1068333-macro-special-copy-paste.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).