I have a large amount of data which I need to analyse, unfortunately this is
presented over 2 or 3 sheets. Is there anyway of creating a single pivot
table incorporating all of this data, or linking the sheets in order to do
this? Currently, I am creating a pivot table for each sheet and then
copy/pasting each pivot table into a new sheet and then creating a new pivot
table, however this is long-winded and can only be based on the field in the
original table