Hello,
I have multiple workbooks all with a commonly formated "Current" worksheet. I would like to execute a macro from a "Summary" workbook that collects data from the "Current" worksheet of these multiple workbooks. The data I need to copy is entire rows based on the value in Column A.
For example - if column A = "Staff", "Services", or "Contractor" I would like the entire row copied over to the active worksheet in the "Summary" workbook starting at the first empty row.

OR, in the reverse

From the "Current" worksheet a user initiates a Macro that 'publishes' entire rows based on the value in Column A to a single "Summary" workbook. In this case it could write to a worksheet with the same name as the active workbook and overwrite any exisiting data.

Ultimately what I need is a single worksheet of rows of data from multiple workbooks against which I can create pivot reports.

Hope this makes sense and thanks in advance for your help!