Yer gonna kill me but i just came up with one more item i need added to the VBA code.

WHen the button is pushed I need it to do everything that has been requested...and I would like it to Email itself (meaning only sheet 2 or 3 whichever is being processed) to the company that is billing me.

This last request is something i am not even sure you can do.