This is what I am trying to do and I cannot figure out the formula. I have searched every helpdesk possible and no one seems to know what I am needing to do

I have a work book that is divided into quarters (quarterly paperwork for the fire department). The first four sheets are are my "core" sheets that I put all of my information in. I have the FORMULAS that will calculate what data I put in as far as calculating but when I try to create the formula to carry over a name, it doesn't work.

If I type in Jane Doe on sheet 1 A241, I want it to automatically fill sheet 2, 3, 4, and Jul (for the 3rd QUARTER).

The names of the sheets are as follows;

# FIRES MADE - INSIDE
# FIRES MADE - OUTSIDE
# MEETINGS MADE
EVENTS

Please help before I PULL my hair out!!!!

Thanks,
SheilaHi,
I have not worked on spreadsheets divided into quarters before, so I am not sure if this will work,
Click into the cell you wish the name to carry over to and press =, then click on the cell the name appears on sheet A241, then click on the tick in the formula bar. Hopefully the name will carry over.