I am using a master spreadsheet to collect data from several project
spreadsheets.

Some of the older project spreadsheets are missing the most recent data
cells, and I want to update the appropriate cells via a macro.

after opening the old file from my master spreadsheet...

Sheets("REPORTING").Select
Range("B87") = "Abv from L4 Request"
Range("D87") = "=L4_Request!Q44"

The second cell ends up as text. I need it to work as a function.