Copying data from multiple workbooks into a blank one.

Hello.I have a big problem ( for me ) and maybe a small one for you.I need to tell you that my VBA & Excel knowledge is almost 0 . So here's my problem: every week i receive like 100-150 excel files with a lot of data and i need to make a new one which should contain only a couple of data from each one. For example,i receive information for evey employee and i need to provide,let's say,only the name,id and location.I searched on google about this and i found some things but i have big problems trying to modify the code so it can work for my case. I am trying to understand the logic behind the VBA code ( i have some experience with c++ ) but i have some problems.

Can anybody please help me ? Or at least explain to me how i should do that thing ? Thanks in advance.

So, i have a lot of workbooks like the "workbook" one with different data but the data that i need to collect is stored in the same row & colums.In the end, i have to make a new worksheet that stores the data like the "final" one.Cod site is found at : D5->E5,Nume site :I5->M5,Contractor:K8->O8 and Data vizitei:K10->L10.

I tried to run the code but i have the following error : Object doesn't support this property or method.

alansidman,

When running code, the error occurred to me Object doesn't support this property or method. and has been highlighted, this row of code:

Please Login or Register  to view this content.

Now i have this error : Method open of object 'Workbooks' failed at this line: Set wb = Workbooks.Open(Filename:=myPath & myFile).

Anyway,can you please help me to understand the logic behind this piece of code ?

lr = wbx.Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
wb.Worksheets(1).Range("D5").Copy wbx.Sheets("Sheet1").Range("A" & lr + 1)
wb.Worksheets(1).Range("I5").Copy wbx.Sheets("Sheet1").Range("C" & lr + 1)
wb.Worksheets(1).Range("K8").Copy.wbx.Sheets("Sheet1").Range ("E" & lr + 1)
wb.Worksheets(1).Range("K10").Copy wbx.Sheets("Sheet1").Range("H" & lr + 1)

How does the program know how many columns it should copy? For example D5.It starts copying from D5 and when does it know when to stop?

Ok now it works perfectly ! Thank you so much <3

Is there any chance of copying the data without borders,bold etc ? I mean only the text.