Hi,

Difficult to comment since I don;t understand why all the sheets are needed. Your Invoice seems to based on the data on the Formula sheet and not the Input sheet, which is sort of counter-intuitive and confusing. In addition presumably the Formula sheet is meant for one particular employee and there will be many of these. However the 'Name' column has days in it, which again is confusing.

You need a single input sheet with columns for all the information that you want to capture. Typically these will be Name, Date, Start, LunchOut, LunchIn, End,...etc.

Create a new row every time you want to record an employee record so that you have a simple 2D table with no subtotals or other extraneous information. When you've done that, post back saying how the invoice should be summarised using the new table.