Copying specific data to a specific field in a worksheet macro

As per topic, I got a list of files in my drive. I would like to put the list of names of the files on a worksheet and a macro button to recognise the list and copy a certain column of data from a specific worksheet from the list of files into a separate file that I am on. How do i go about this?


Thank you
cheers
brad peh.

Image001.JPGImage001.JPGcould someone help me with this? thank you!

Image002.JPG Can someone help me this? I'm getting stucked trying to do this.

i tried searching online to no avail. i use the specific key words to search for the right key terms to find how to solve my macro issue. I have a bit of programming backgrd but i'm not good at starting from scratch, been searching for a template to begin with but to no avail as well.

My question is

I have 2 sets of directory with simiarly named workbooks example A,B,C and A1,B1,C1 both in different directory but they have similarly named sheets and I would like to do a template whereby I can specify which cells and which sheets to copy and paste into. I can't find searching within past questions past because there ain't any specific cells copy and paste into. If there is, maybe I didn't do enough digging. Could someone help me with this? Thansks!