Need help flipping multiple objects in a collection as a whole
I might be missing something but the problem seems simple to me.

With your first described attempt you were using Individual Origins.



But I think you want to use Median Point while mirroring, and you'll get the desired result.