How can I write a script to print all pages from a section.

With Prism 5, use the ForEachSheet command.

ForEachSheet
  Goto D %N 
  Print
Next

Prism 4 does not have a script command to "loop over all sheets", but this script will do the job:

ForEach 1000
  Goto D %N 
  Print
Next

That loops 1000 times (or until it hits an error when it runs out of sheets). Each iteration, it goes to the appropriate data sheet and prints. When there are no more sheets, you get an error message and are done. Substitute "G" or "L" for "D" if you want to print all graphs or layouts instead.