Excel VBA Copy multiple sheets into one sheet not working -

I have the following VBA: data is all text, row A - J with column header on each app are the same data " Top Sql queries with top 1,000 "4 sheet ( sheet1 , sheet2 , sheet3 , master )

Sheet 1: 100 Rows Sheet 2: 34 Rows Sheet 3: 900 Rows Master: 3 Merged Data from Sheets

Issue: Sheet 3 Only 84 Rows Copy specifically for other sheets Fie rows will be copied to the master only sheet3 will not copy more than 84 lines.

'Step 1: Clear Master before updating' Step 2: Loop through Regional Sheets

Sub-integration ("A2: Z65536"). Category ("A2: Z65536"). Worksheet for Works Works in this Workbook Wks.Name & lt; & Gt; "Master" and wks.Range ("A2") & lt; & Gt; "" Then wks.Range (wks.Range ("A2"), wks.Range ("A2") for each cell. End (xlDown)) cell.EntireRow.Copy Destination: = Worksheet ("Master"). ("A65536"). End (XLEP). Offset (1, 0) Next cell and if next wks

ending sub

thanks

What is always starting from range (A2) ?

wks.Range (wks.Range ("A2") for each code, wks.Range ("A2"). End (xlDown)) will begin with A2 and before the empty / empty cell go to the cell with the previous population.