Excel design/formatting tricks/fitting to one page to print/creating pdf memo from spreadsheet

Okay hi I've never posted to this group so I apologize in advance if my post is not up to standard.

So I work in commercial real estate for a lender (very new its my first year and I'm not the analyst I'm just an executive assistant so I dont know excel very well) and I need to take an existing spreadsheet that has a million cells linked to other sheets and is not organized well at all, and turn it into a clean looking memo we can send to our investment committee.

I have spent hours trying to resize and reorganize the data (which are in sections that vary in size but are mostly tables) so that it will fit on one "page" when converted to pdf, where the text is big enough to read, and all of the data fits without getting cut off.

The various tables overlap in columns and rows, whoever made this originally did not plan out the format well at all. If you widen a row at the top because a title line needs more space, then somewhere below a different table has too much space in that column or row, or vice versa. ITS IMPOSSIBLE. Wish I could start from scratch but cant due to the links (or its just beyond my ability)

It would be much easier to use Adobe to create a memo, and I've contemplated taking screenshots of the sections separately and then pasting them into a collage template on Adobe or something. I think that might be the only way I can do this.

If anyone has any tips for the above please let me know, and if not any tips for creating a spreadsheet that is formatted to be easily convertible to pdf while being aesthetic enough to send to people, I would really appreciate your ideas for next time so I dont have to deal with this bs again!

Thank you!

-a very stressed girl who will be very grateful for any help