DATA retreival

I am trying to create an excel worksheet that is a fillable form that will auto populate related worksheets. I am looking for some direction, is there anyone that has built something of this nature?