Take values from multi sheet and copy to a summary page

[egchristensen]

I have a workbook that has multiple sheets, which have values including ones based on formulas. I need to copy only the cells with values not the cells with formulas.

See the attached example workbook.

What I want on the summary sheet is only rows with values not formulas. I have a formula in A3:A40 and G3:G40. The code I have is pulling all rows 3 to 40 and copying to the summary sheet, I only want the rows that have data.

I think it might be in the function Lastrow and Lastcolumn but when I tried change LookIn:=x1 Formulas to Lookin:=x1 Values , it ran until I reached the point to paste to the summary sheet then I got an error.

[Arkadi]

it is not x1 but xl (letter "L" not number "1") xlvalues/xlformulas

[egchristensen]

That was just a typo in the comments.
The code works and is correct.
I just need to know how to make it only copy the values. because it is copying everything as it is now.