$$Excel-Macros$$ I Need macro to export pdf files

Hi experts, I have create a macro that changes the cell B5(do while Loop) in the attached file and accordingly the other details. Now what exactly i need is as and when the No changes i want the named range we in the attached file to create a pdf and the run the code which will the be the next

$$Excel-Macros$$ Update the Data from Different Sheet one below the another

Dear Experts, I am held up with the small problem facing with my excel project. I need to update the Data from different sheets on to one of the sheets which should get updated ,with the data getting updated one below the another as and when updated by the other sheets. Visual Basic or Macro