If cell contains text then cell will pull text and other information on to another sheet

Hello I wanted to do a few formulas to help me out with payroll and bonus

Im trying to create a formula that would pull all data from one sheet into another and sort employees hours and performance. What makes this difficult is the each employee on the sheet I currently have do not always stay on the same row or column. I want the formula to recognize that Chis M. is working pull all his data such as total hours, pay rate, total pay, and rev/hr and copy it to another sheet with his designated name. This way I can get an aver of all his stats, and stats for each employee.

I've attached my sheet hopefully someone understands what im trying to do.

I would recommend changing the layout of your data as does not lend itself to easy manipulation/calculation of data, particularly doing calculation across sheets.

Column headings as below in one sheet.

Date Route Mover Start Time End Time Total Hours Pay Rate Total Pay Rev/Hr

This does not help because each route needs to be separate.

Your current request illustrates the problem:

Let's assume Chris M works 4 days in week beginning 31 Jan. To extract his data we have to look at columns F, N,V, AD, AL, At and BB and the rows within these ,to see on which of these days he is working. I doubt if this can be done using a formula.

If the data is in the format I recommended, this becomes a relatively simple task for a given employee.

You need to specify exactly what data is be extracted and what is the format of the output.

Im trying to find a formula that will recognize Chris M and extract the data from the next 6 cells onto a separate sheet, and place only Chris M data in that section of the sheet. this would go for what ever other employees work. I've seen it done, the person who created it wont give me access to their formulas.

Extract for one day is OK: extracting for a week i.e 7 blocks of 6, is much more difficult.

For a given week, you could simply use VLOOKUP or INDEX/MATCH.

I am not deliberately trying to be awkward: I have seen similar cases where extracting data from this layout is difficult.

I repeat that file showing your expected outcome would help to avoid me (or anyone) going down the wrong path.