A pivot table is one way to do this, in which the business name would be the
filter you apply to the pivot table.

Other functions to consider would be VLOOKUP and SUMPRODUCT, depending on
what you want to do and how your data are structured.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"walkerT" wrote:

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....