For example; I will copy cells A10,B10,C10,D10,H10,Q10, and R10 only if Q10 has data entered. Any formulas to automate this process??
There are a number of ways to "automate" the process, depending on how you define the term.

You could use a VBA macro (if that is an option for you), or you could simply link the cells on sheet2 to cells on sheet1.

Example: on sheet2, cell A10 might use this: =Sheet1!A10

You could also use Advanced Filter with criteria and use the option to copy matching records to a new location. This, too, can be automated to be run when criteria changes.

It is always helpful to post a sample workbook that accurately reflects your real WB and contains non-sensitive data of the same type your real WB uses.