I've got one spreadsheet where I have all my VB working from and I collect data in that spreadsheet and attempt to write it to another summary spreadsheet. What I'm attempting to do is paste data in different sheets on the 2nd spreadsheet based upon a data entry in the initial spreadsheet.

I've attempted to use WorkSheets, Sheets, Activate, Select, etc. I've come as close as pasting all data to the first sheet among numerous other errors. Any ideas?