Help: Create Pivot Table from multiple tabs in a Spreadsheet

Hi there. I am using Excel 97 and would like to create a Pivot from 3 identical Tabs in a spreadsheet (each has 1 different column but each are formatted the same with identical headings) Is it possible with this version? Any help would be very much appreciated. Thanks

Thanks for the help. I am still messing with your solution but not getting too far. I have done it the long hand way by copying the sheets into one which does the job but is not very neat. Hopefully I'll crack your way soon.