I need help detrmining what function I need to research so I can create a
formula for my worksheet.

Example: I have 4 different worksheets that have payroll, marketing, and
fixed cost for 40 businesses. I want to create a worksheet that will allow
me to pull the data from each years spreasheet for payroll, marketing, and
fixed cost by simpling typing the business name in my master sheet so I dont
have to create 40 worksheets seperatly.
Will I need to create a PIVOT TABLE or should I use another function? Any
help is greatly appreciated....