AutoBlogging...I really want to make this work

Hello all. Yes, I am back. But this time it's different. Since I've last posted on here, I accidentally erased my website database. Yikes! So I have had to pleasure of trying to rebuild it; so it's kind of empty right now.

My site is about ways to make money online. I have several categories discussing these methods. Because I have so many different categories I tend to want to add an affiliate product for each category.

Then, I realized that I could probably build a niche around each one of my categories and have relevant affiliate products for each with some Google adsense ads included. The problem is, I don't want to dissect this current site I have up. I personally like it.

I know auto-blogging requires certain skills; and I really want this to work.

I have my own personal posts, but I have also went and manually pulled some content from other sources. I have an autoblog software, but I don't know if I should use it with my website having so many categories. The software may not know where to put the content; and because I have my blog set on a homepage rather than the 'latest posts' I feel the software would be confused. I could just take the chance.

I really want my site to give good content, and pull in sales, but I am wondering if I should brake up the categories.

Have any of you had this experience before? What worked best for you?
Thanks community!