Generate output in sheets and create power point slides for that output..

Hi..
Require Help in doing this automation..through VBA Code. If any one can help, will be highly appreciated.. I have one file with main database and other three output sheets e.g. slide 1, slide 2 and slide 3. (This is sample database).

At his moment, sheets slide 1, 2 and 3 is displaying data output for Department=Sales A.. Accordingly, when one selects, Department=Sales B, these three output sheets will show data for Sales B and so on.

Sales A, B, C etc are department names...

Now I require to generate powperpoint file with these output sheets i.e. Slide 1, 2 and 3. The Powerpoint file (with slides Slide1, Slide2, Slide3 on below other) thus generated also required to be saved as Sales A.ppt, Sales B.ppt etc..for respective output generated. I have already posted above both the files..(input and output required)..(uploading both excel and output file in powerpoint).

Thanks and Regards,

KBM