Hi, I created a payroll in the excel sheet called sheet1. It contains the entire list of all the employees. Now I am creating individual sheets for everyone in the same workbook. Is there any option if I change the salary details and the allowances in sheet1, it should also reflect in the respective sheets automatically? Your help and opinions are most welcome

In order to achieve this, you will want to use a formula in the individual sheets that references the salary details and the allowances cell(s) in sheet1.

The formula in the individual sheets would be something like this:
Replace "A2" with the cell reference that you want to be applied to the other sheets.

Regards,

Ax