I am creating a report for my boss. In one worksheet I have fields where she
can enter text or numbers. Then in another worksheet I have some formulas
that work off the previous worksheet. I need a function that will copy the
text in a column on the first worksheet and place it in a specified cell on
the other worksheet.

I hope this makes sense. Example:
Cell A1 in Worksheet 1 = Financial Manager
Now I want to copy Financial Manager into Cell B4 in Worksheet 2

The trick is the text in cell A1 in Worksheet 1 will always change depending
on what my boss puts in it. But I want it to always copy to a specified cell
in the other worksheet.

Thank you!