Excel: Pivot Table with Multiple Consolidation Ranges

I want to build a pivot table based on multiple consolidation ranges. Specifically, the same cells across several worksheets. The names of the worksheets are stored in a table called loSheetNames, so I need a way in the code to add them to the pivot table.

When I record the steps, the statement that actually makes the table is this: