How would one create a single list of #'s (array) from multiple lists (arrays)?

Situation: I have data in multiple pages and I want to get the 95th percentile of a large array, combining data from each of the pages

The formula for Percentile requires the syntax as follows: PERCENTILE(ARRAY,k) where ARRAY is a continuous list, and K is a value between 0 and 1.
Here is the formula I tried:

Formula:

=PERCENTILE('sheet1'!AG4:AG119,'sheet2'!AG4:AG143,'sheet3'!AG4:AG117,'sheet4'!AG4:AG144,0.95)

In the formula above, the italicized array contains multiple arrays within the list.

The problem: Excel cannot read past the first comma, thus, Excel is interpreting the multi-component array as:

PERCENTILE('sheet1'!AG4:AG119,(not k) blah blah blah blah….) and obviously returning an error.


This didn't work:

Formula:

=PERCENTILE(CONCATENATE('sheet1'!AG4:AG119,'sheet2'!AG4:AG143,'sheet3'!AG4:AG117,'sheet4'!AG4:AG144),0.95)

Can anyone provide some light as to how to enter multiple arrays as a single array (where a comma separates the operators)?