Using Pivot table to filter across multiple worksheets?

Hi, Newbie here, so apologies for lack of protocol.

Is it possible to use Pivot table to solve the following need:

I have a column called Sub_ID present in multiple worksheets. The values in the column are not unique in that they are repeated multiple times for different laboratory results. Each worksheet has a different set of data for the Sub_ID. I'd like to filter so that I can see all of a particular Sub_ID info at once, without summing, counting or performing a function on the summarized data. One option is to bring the data together in a Pivot, but I've had no luck because Pivot tries to summarize by applying an operaton. Another option is applying a filter across all worksheets so that a particular Sub_ID is displayed, but so far, this looks like I need to write a macro, which I am not yet up to speed with.

Any help on this would be appreciated. In addition, if someone can recommend a good self-tutorial for learning VB/Excel Macro I would be grateful. I am trying to get up to speed on doing more with Excel and I know much of what I may need will require some knowledge of VB.


Thanks in advance for your assistance!
Tom

Hi Marvin
thanks for this...i have tried the wizard, but will try it again. The problem i had with it is that it tries to sum the values...in addition, pivot doesn't seem to see the fields as the same...i think to do that, you have to make the tables relational, but the values in my Sub_ID field are not unique, as they are repeated many times for each value sub_ID is referencing:
Here is an example

Worksheet 1


Sub_ID Medical Hist Active (Y/N)
101
101
101
102
102
103


Worksheet 2
Sub_ID Medication Date started Date stopped Indication
101
102
103
103
103


Worksheet 3
Sub_ID Result Ref low Ref high Date Abn (y/n)
101
102
102
102
103


t