[Solved] Calc data from multiple sheets

[erosencrance]

Using Calc I have sales team data from multiple weeks for each member of my sales team. I want to extract that data and create a spread sheet of each persons individual #'s to look at trends and patterns. is there an easier way other than cut and paste for the program to automatically pull that data out.

[RusselB]

If you have one sheet per member, create an extra column and copy & paste the data for each person into the main sheet, adding the team member's name in the extra column.
Once you have all the data in one sheet, you can use a Pivot Table (aka DataPilot) to extract all kinds of information.
You might be able to do it with the data being on different sheets, but I'm not sure.,,, I've never tried to use the DataPilot from multiple sources.

[erosencrance]

Thanks for the suggestion.
I found my solution though on another forum list. I used the DGET function and then just used a validity list in the lookup field to each persons data out individually.