Okay, so I'd have to include a "lastrow" variable. How do I write my range in creating the pivot? Something like this? 
"'Summary View'!A1:D" & LastRow