I have 50 worksheets that are specific to one person each. I have a master
sheet into which i want to automatically pull specific data from each
individual worksheet. What is the correct formula so that the master sheet
will automatically pull data that i enter into the individual sheet so i
don't have to copy and paste everytime. I want to be able to have the master
file contain specifics from each individual sheet and be able to sort from
there. Is there a formula to do this and then pull it down so i don't have
to do individual formulas for every sheet?? Any help would be great, thanks!