Hello Everyone,
I want a macro to import data from a workbook with few sheets, the workbook has the same worksheets now what I need is only few values from let's say two worksheets. File name will change for every customer, can I have a openfilepath then I will locate where is the workbook is, from that workbook look in the worksheet and read the values I need, each time I click the macro I want to have values in rows like 1,2,3,4 down, macro has to know where is the empty row. example file #4432 I only need like the date it was created, project amount, paid balance. Can anyone think of a code that would be possible?

Thank you,

I have this code so far,

Sub GetOpenFile()
Dim fileStr As String
fileStr = Application.GetOpenFilename()
If fileStr = "False" Then Exit Sub
Workbooks.Open fileStr
End Sub