Automatically Populate a Worksheet (rows/columns) in a Different Workbook based on Value

I am looking for a way to automatically copy/populate a worksheet within a different workbook based on a value that would be added in a cell.

There would be a workbook for each unique ID, I would need the line item associated with that ID to auto-populate from Workbook Source to the Unique Destination Workbook

ID 1144222 would have the same table format as Workbook Source and if the ID matches, that line item would automatically pull in. (note: this could be up to 100s of lines)

Is this possible? if not for a separate workbook, what would it be for a separate worksheet within the same workbook?

Really looking for an efficient way to manage a lot of work that requires oversight and will require management of several separate workbooks.

I am not savvy with vlookup formula or VBA, but can pick it up quick if explained if that is what should be used.

Thank you for any guidance.