|if I am understanding you correctly this is what you are attempting to achieve|
You have four worksheets
Sheet1: Main Sheet
How would I pull the information just for each persons record?
So what you want to do is, enter a name in the Main Sheet in a cell somewhere, for example you enter 'Steve' now you want to pull some data from sheet 'Steve' and present it on the main page?
I maybe wrong but this is what I understood from your post, please describe your requirement exactly and keep in mind we cannot see your workbook from where we are so we need to know exactly what you have and exactly what you need. I don't think this is achievable with formulas, you will need a VBA solution.