On This line
 Destination:=ws.Range("AZ95" & nextRow) 'Getting an error on this line
ws refers to your active worksheet...What is the name of the worksheet you are sending info to.