Without seeing the two workbooks directly, not sure I could imagine a formula approach. But a macro could be run to do this pretty well.

If you provide the names of both workbooks (specify which is which), the full path to where you store these workbooks, I can help with that.

The macro would:
1) Open the "output" file if it isn't already open.
2) Go through all 18 sheets and "filter" the original workbook by the "name" of each worksheet in the second book, copying into the 2nd wb all the rows matching the sheetname.
3) Save the Output wb and/or close it again. (Your call there)

Let me know.