Using sheet names in complex functions

[JinTHR]

Hi everyone,

Hope everyone had a great new years!
I'm trying to set up a function that uses data from a different cell to designate what sheet in the workbook to look to for more data.
Example would be I have 10 sheets of sales data for a company. On a separate sheet I have a complex function that need information from 4 of the 10 sheets of sales data at a time. These 4 sheet change from time to time, so I wanted to create a drop down menu with the names of the 10 sheets in it and have the sheets' names plug into the complex function. Let me know if this is unclear and I'll come up with an example.

Thanks everyone!

 

[Andrew Poulsom]

Welcome to MrExcel.

It sounds like you need to use the INDIRECT function. Check it out in Excel Help.

 

[JinTHR]

Andrew,
That did the trick! Thank you so much for all your help.

Take care and have a great day!