Ttest across multiple worksheets
 

Hi there
I'd like to conduct a TTest across multiple worksheets. I have datasets where the values to be compared are in eg: 1!A1, 2!A1, 3!A1 etc (group 1) and 1!B1, 2!B1, 3!B1 etc (group 2)
Using the ! function allows me to get mean and standard devations across the multiple worksheets but it doesn't seem to work for the Ttest.

Any suggestions?

Many thanks,
Tim