I have a sheet named Tracking File and the value that I want to use for reference is contained in Column A, let's call Column A, order_id.

The Tracking File workbook only contains the order_id column, but I need to be able to find each of these order_id values in other sheets (or workbooks in the same folder), and copy over the entire rows which include additional values/columns in addition to the order_id.

I don't mind if it copies over existing rows in the Tracking File, or if it simply adds the new rows to the bottom of this sheet.

Is there an easy way to do this, because the order_id's are spread across multiple other sheets right now, which is why i said i can bring all of those sheets into the same workbook, if that makes things easier?