Can Acrobat create the forms that Excel cannot?

Hello to the Forum, and thank you for any help you're able to give. For some reason, my office has decided I'm the resident expert on Excel (I know this isn't an Excel board, please bear with me - it will all make sense) and asked me to redesign a very elaborate Excel spreadsheet they use as a giant production checklist/information form. This monster is actually 22 separate forms, organized as worksheets, including some that are simply fill out forms, others that are nothing but pasted images of legal paperwork, others that are checklists with drop-down selection boxes, and even some budget calculation worksheets with actual formulas. There's some script and macros, and lots of inter-sheet references. They asked me to streamline it and make the check boxes work properly.
 
As you may know, check boxes in Excel are designed to be used for yes/no answers to be used in macros and VB script, but these are to be used visually, as just a plain old check box. When printed the check box turns into a giant X that fills the whole cell and doesn't align properly. So, I was asked to fix this.
 
Turns out, there's a lot wrong with this whole spreadsheet, and by asking me to fix this one cosmetic flaw I'm uncovering a whole can of worms. Bottom line: Excel sucks at forms.
 
So I'm looking for an alternative, and Acrobat might work, or will it? That's my question to the forum.
 
Requirements:
 
It needs to be able to do basic calculations like Excel, but be easy to use like a HTML page.
 
The form should be able to be saved as a unique file for every production.
 
You should be able to pull out a single section of the form and send it to clients/vendors for them to fill out - thus the client/vendor is privy to only their information and not the whole production.
 
It should be easy to fill out and make an attractive and easy to read print out. If that means there one form for data entry and another for printing/emailing then so be it.
 
The data from the one page should replicate to other pages. Ie, "Production Name" from page 1 should automatically be filled in on pages 2, 3, 6, 12, 19, 22, etc.
 
Check marks should look like check marks.
 
It would be nice to be able to navigate around this massive collection of forms by tabs (like Excel) rather than have all of them run together as one huge document (like Word).
 
There may be other requirements, but that's enough for now. So the question again is, can Acrobat do all this, or should I be looking elsewhere? And if Acrobat can do all of this, is there some Acrobat wizard on this forum that wants to be paid to do it? I really don't have the time, and I think I can convince my superiors to spring for it. Any takers?
 
Also, if we need to all upgrade to Acrobat 10 I think we can swing that, too.