How do I enter data on a worksheet and have it populate on other worksheets within the workbook

On worksheet 2 put (='worksheet1'!A1) if the names are in cell A1

Actually it should be:
=Sheet1!$A$1

This is helpful but here is what I am trying to do.  I have a workbook that users are filling out and there is different info on each tab but for example ID # firstname, lastname repeats across worksheets.  I want them to be able to fill out the information on the first sheet and then when they go to the other sheets the basic demographics are pre-populated based on what they entered on the first sheet.  This will work but I would have to put the formula with a row number in every row/column.  Is there a way to do this without specifying the row and column?

Yes using a macro. :)

If you can upload a sample file then maybe I can help you?

Sid

Attached is a sample of the file.  I would like to enter the last name and first name for example on the demographics sheet and have it carry over to the sheets named assignments and related services.
Copy-of-Case-Manager-Assignments.xls

Thanks!