Q: I have a late 2006 macbook, will any of the new power adaptors work to charge my macbook? if so what wattage would I need?

From Apple:

Although the replacement adapter may not have the same connector shape ("T" or "L") or wattage as the original adapter that came with your computer, newer adapters should power and charge your MacBook, MacBook Pro, or MacBook Air just like the adapter that originally came with your computer.

http://support.apple.com/kb/HT2346

https://discussions.apple.com/message/13177770#13177770

https://discussions.apple.com/message/4216322#4216322

As dalstott's link  : http://support.apple.com/kb/HT2346 says

newer Magsafe 2 adapters will not work, but old-style Magsafe ones will.

You need 60W

Apple 60W MagSafe Power Adapter (for MacBook and 13-inch MacBook Pro) - Apple Store (U.S.)

You can get a new third party 60W power adapter on eBay for under $20.

http://www.ebay.com/sch/i.html?_nkw=macbook+power+adapter&_sacat=0&_sop=12&_dmpt =Apple_Laptops&_odkw=macbook+power+adapter&_osacat=111422&_trksid=p3286.c0.m270. l1313

Or for $80 from Apple http://store.apple.com/us/product/MC461LL/A