Hello,
I need help to update Main sheets from other Sheets
Example
Main Sheet
<tbody>
</tbody>
Sheet1(Jul-19)
How will automatically Emp ID & Name updated in Main Sheet
<tbody>
</tbody>
Sheet2(Aug-19)
In August 2019 New Employees Joined
How will automatically add in Main Sheet
<tbody>
</tbody>
Sheet3(Sep-19)
In September 2019 One employee left and other Joined, How to update both.
<tbody>
</tbody>
I need help to update Main sheets from other Sheets
Example
Main Sheet
Emp ID | Name | Gross Salary | Tax | Net Salay |
<tbody>
</tbody>
Sheet1(Jul-19)
How will automatically Emp ID & Name updated in Main Sheet
Emp ID | Name | Gross Salary | Tax | Net Salary |
01 | Saeed | 1000 | 100 | 900 |
02 | Ahamad | 1000 | 100 | 900 |
<tbody>
</tbody>
Sheet2(Aug-19)
In August 2019 New Employees Joined
How will automatically add in Main Sheet
Emp ID | Name | Gross Salary | Tax | Net Salary |
01 | Saeed | 1000 | 100 | 900 |
02 | Ahmad | 1000 | 100 | 900 |
03 | Muhammad | 1000 | 100 | 900 |
<tbody>
</tbody>
Sheet3(Sep-19)
In September 2019 One employee left and other Joined, How to update both.
Emp ID | Name | Gross Salary | Tax | Net Salary |
01 | Saeed | 1000 | 100 | 900 |
03 | Muhammad | 1000 | 100 | 900 |
04 | Ali | 1000 | 100 | 900 |
<tbody>
</tbody>