Can I aggregate all stylesheets core, contrib and custom into one single stylesheet?
Enable aggregation of css by going to admin/config/development/performance

This is the best Drupal 7 can do without the need for any contrib module 

You can also try Advanced CSS/JS Aggregation which gives some more advanced aggregation.