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

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>

 

[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.