To automatically copy data from one sheet to another in Excel, use the formula =SheetName!A1 on the destination sheet. Replace SheetNamewith the source sheet's name and A1 with the cell reference to copy. This formula will retrieve data from the specified cell in the source sheet and display it in the destination sheet dynamically. You can replicate several cells by dragging the formula across the required range. Any changes made in the source sheet are automatically updated in the destination sheet using this method.