Hi, I've created a new form for our engineer to enter their project information on and requirements and I'd like to copy certain cells from each new form into an overall form to help track the projects status. I created the button and tried to find some code but haven't come across any that matches what I need. So far my button will let me select the individual form I'd like to update from but that's about it. Then it copies it's location into my selected cell. As I go along I'd like it to update the next free row so that it doesn't the previous entry. Is there a way to do this through VBA? I wasn't sure if there was a way to use the file selected in the 'varFile' below and then also tell it to copy for example cell B11 on the engineer form to cell 'next available row, column 3' etc. Any help or guidance would be great! Thanks.

Private Sub CommandButton1_Click()

Dim varFile As Variant

varFile = Application.GetOpenFilename("Excel files (*.xls), *.xls", , "Select a file", , False)
If varFile = False Then
Exit Sub
Else
ActiveCell.Value2 = varFile
End If

End Sub