VBA Code/Macro for Extracting data from Sheet 1 to Sheet 2

[joy_joy111]

Hi All Experts and Masters !!
Good Day.

I am very new to this forum. apologies if posted in incorrect forum.
I am looking for some help - I want to write a macro code -- Version of Excel: Office Professional Plus 2013What you want it to do -- Write a macro - Extract/Scrape data from multiple 1000+ rows of Excel(xlsx) sheet 1 into specific distributed column in excel sheet 2 (xlsx)


Sample in screenshot may give more idea (Click download if very small) .

111Excel REq.jpg


I tried to refer some threads but I was not 100% success. Please help. !!