You can use INDIRECT but you haven't provided enough info to make a more
specific suggestion.

--
Biff
Microsoft Excel MVP


"Jammings" wrote in message
...
Can I sent a formulae in the column one sheet such that the column to the
right pick up data from the sheet to the right of the current.

eg there are four sheets
first sheet - master sheet
second - january
third - february
Fourth - march

Column b should read data in january sheet
Column C should read data in February sheet
Column D should read data in March sheet