I have a workbook with multiple sheets. I'm trying to create a macro that
1. Goes into 4 specific sheets (I'll call them A, B, C, D)
2. Searches column "C" for a specific date
3. copies the entire row for which the specific date is present
4. Paste those rows into another worksheet (called "Output") - the first row of the "output" has headers so I would ideally want the data to be pasted from row 2 on down.