I have a macro that loads data from another workbook when a button is pushed.
Currently it only pulls data in from one cell using the following lines of
code:

With Sheet23.Range("A1")
.Formula = "= '" & module1location & "sheet2'!A3"
.Formula = .Value
End With

Shortly, I am going to be pulling in a lot more data from different cells
from "module1location". Is this the best way to be doing this? Seems like I
remember someone saying "don't fix what ain't broke..."

Thanks for any help,
Chris