Automatically update Main Sheet from 3 or more other Sheets

[khanzgem]

Hello,
I need help to update Main sheets from other Sheets

Example
Main Sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Emp ID[/TD]
[TD]Name[/TD]
[TD]Gross Salary[/TD]
[TD]Tax[/TD]
[TD]Net Salay[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet1(Jul-19)
How will automatically Emp ID & Name updated in Main Sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Emp ID[/TD]
[TD]Name[/TD]
[TD]Gross Salary[/TD]
[TD]Tax[/TD]
[TD]Net Salary[/TD]
[/TR]
[TR]
[TD]01[/TD]
[TD]Saeed[/TD]
[TD]1000[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]02[/TD]
[TD]Ahamad[/TD]
[TD]1000[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet2(Aug-19)
In August 2019 New Employees Joined
How will automatically add in Main Sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Emp ID[/TD]
[TD]Name[/TD]
[TD]Gross Salary[/TD]
[TD]Tax[/TD]
[TD]Net Salary[/TD]
[/TR]
[TR]
[TD]01[/TD]
[TD]Saeed[/TD]
[TD]1000[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]02[/TD]
[TD]Ahmad[/TD]
[TD]1000[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]03[/TD]
[TD]Muhammad[/TD]
[TD]1000[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet3(Sep-19)
In September 2019 One employee left and other Joined, How to update both.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Emp ID[/TD]
[TD]Name[/TD]
[TD]Gross Salary[/TD]
[TD]Tax[/TD]
[TD]Net Salary[/TD]
[/TR]
[TR]
[TD]01[/TD]
[TD]Saeed[/TD]
[TD]1000[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]03[/TD]
[TD]Muhammad[/TD]
[TD]1000[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]04[/TD]
[TD]Ali[/TD]
[TD]1000[/TD]
[TD]100[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[vcoolio]

Hello Khanzgem,

See if you can adapt the code in post #2 of this thread:-

https://www.mrexcel.com/forum/excel-questions/1103015-returning-data-multiple-worksheets.html

I hope that it helps,

Cheerio,
vcoolio.