I would like to know if it is possible to use pivot tables to compare two
years data.

Each year spreadsheet consists of headed columns which I can use to create a
seperate table for each year however I would like to keep the same column
heading facility but import information from th previous year so that I can
produce a comarison table with all informtion on.

I very much appreciate any information you can give.
--
pk