Automatically copy rows from one spreadsheet to another

[Rosstamon]

I have a series of spreadsheets in their own workbooks but all contained within the same file folder in my Mac. I would like to create a new spreadsheet that would monitor these other sheets and when the word "Call" appear in column H of any of the spreadsheets the entire row is copied and added to the bottom of the new spreadsheet. Is there a macro, or something else that would work here? If it's VBA, I'm not at all familiar with how to process a set of VBA commands so a little extra help with that would be appreciated.

Thank you,
RR

 

[My Aswer Is This]

The term Spreadsheet has been eliminated from Excel terminology.

Excel now uses the terms:
Workbook and Worksheet.

So you said:

I have a series of spreadsheets in their own workbooks

And then said:

and when the word "Call" appear in column H of any of the spreadsheets the entire row is copied and added to the bottom of the new spreadsheet.


​

_{^{<strike>
</strike>}}​

So would you please rewrite your question and only use the terms
Workbook and Worksheet.

Then I may be able to help you