Create Excel Report Sheet with VB Button

Thanks for the code Stephen, im not sure if im putting it into the wrong place. I am putting it into the Outstanding Job sheet, when i run it it works well, but when i add more jobs, or jobs done it does not automatically show up the new data unless i go in and run the code again.

I would like to click on the Outstanding jobs button and let that automatically run the code. Im probably putting the code in the wrong place, or am i?

You already have the Click event macro in your module 5 so I just added my code there. Right-click on the button and Assign Macro to check the right one has been assigned. You will have to press the button to run the code though.