If any date from date column is equal to date cell in a separate sheet then pull data.

[Adeel Akbar]

I have a Microsoft Excel workbook which counts the daily profit of my employees. I have created a sheet for each employee, now I want to fill their daily profit in their sheets automatically with formulas. Please help me.
For Example.
Sheet 1 gives me their daily income.
Sheet 2 is for my Employee "Harish"
In this sheet
Column A is for dates, column B is for his basic pay, Column C is for overtime allowance, Column C is his total pay.
Sheet 3 is "John".

 

[Toadstool]

Hi Adeel Akbar,

A few questions:

1. You say "Sheet 1 gives me their daily income. " so each sale must include their name. Can you provide the format please?
2. You say "Column A is for dates, column B is for his basic pay, Column C is for overtime allowance, Column C is his total pay." so I assume it was a typo and column D is his total pay. So for a date for Harish you want the total sales from Sheet1 minus the total income from the Harish sheet for the same date?
3. How is the column ("Extras" to be calculated?