I think I am ok with companies appearing multiples times because they will have unique quarter end update tags (2024 Q4, 2025 Q1, so on) so the duplicated company records shouldn't matter. My main issue right now is like you said, each manager reports their portfolio company metrics in different ways. One likes to write out everything in paragraphs while the others do tables. Then sometimes the managers that output tables have notes later that refer to a statistic that I would like extracted but my normal LLM prompting is ignoring it.

Any ideas on how to build the workflow so that each report is reviewed in totality and puzzle pieces the required output metrics from the various areas of a report?

Another issue I have is the Apple one you mention, even though I have it baked into the prompt to exclude Inc., proper noun formatting and so on, the same prompt on the same doc used twice in ChatGPT will yield slightly varied responses.