How do I auto-populate information from a form I made to multiple sheets.

In order to copy the information from the 'form' sheet to the other sheet would be to use a Macro(VBA) or a Script. But let me ask you if you fill in the 'form' because that is the best way to get the information or because you need to print it out in that format. If it is the latter then I recommend you ENTER the data on the table (expand the log for additional values if needed) and then use the 'form' sheet as a 'report' sheet where you can either default to the 'last' line of the log or enter the Dispatch number and it can pull up all the other values from that log.