Put Geometric Averages Of Each Column From Each Tab In A Summary Tab

I have multiple sheets each containing multiple columns of numbers, and sometimes when the numbers are not present there is a text error string such as "#N/A N.A.", or "#N/A N Ap". An example of the data is as follows:

4.06
1.28
3.411
#N/A N.A.
2.627
1.157
4.9
4.9
2.963

I would like to put geometric averages of each column from each tab in a summary tab.

* I tried using =GEOMEAN(...), but it can not handle the quantity of data that I have nor can it take non-numeric fields.

* Also Tried something like this =EXP(AVERAGE(IF(ISNUMBER(C:C),LN(C:C)))) as an array, but unless cells are specified explicitly, ie c10:c300, I get an answer of 1. I can not specify the cells because I have a variable height of each column.