Do it the same way you reference cells on the same worksheet. In Sheet1, a
reference to cell A1 on Sheet2, will look like Sheet2!A1.

"JJohn" wrote:

I need to pull information from multiple spreadsheets into a new spreadsheet
to develop a monthly recap.