Multi-configurational explicitly correlated wave functions for the study of confined many electron atoms