Excel Formula

I'm running Microsoft 365 excel and need help with a formula. I need the formula that will allow excel to automatically past an alpha cell to another worksheet in the workbook when entered into another. Can you help? I'm good with how to do a numerical cell formula, just need the formula that will 'copy and paste' one alphabetic cell into another worksheet. Can you help?