Question about using Evaluate with an array of formulas not an array formula

I have several lines of code that currently input a formula into several different cells. Basically these cells echo data from one sheet to the dashboard. I would like to only have the values appear if possible. Can this array of formulas be written using Evaluate?

        With .Range("C5:H5")
            .Value = Array("='" & termBox.Value & "'!P2", "='" & termBox.Value & "'!Q2", "='" & termBox.Value & "'!Q4", "='" & termBox.Value & "'!P3", "='" & termBox.Value & "'!Q3", "='" & termBox.Value & "'!P4")
            .HorizontalAlignment = xlCenter
        End With