Steven --

Not exactly sure what you're trying to do, but to bring a value from one
worksheet to another, here's how. Let's say you want a value (number or
text) to update automatically from A1 in Sheet 1 to B2 in Sheet 2.

In the 'target' cell -- Sheet2!B2, type:

='Sheet1'!A1

HTH

"Steven" wrote:

Hi all

I want to collect figures from several worksheets and display them in set
boxes on another worksheet that will act as a template.

I have a sheet with say 50 people on each on their own line. In several
colums their are amounts. I want to move a specific amount to a set static
cell in a completely different worksheet.?

In this new worksheet I want to bering in figures from other worksheets for
each employee (to be done one at a time)

Thanks