Creating an Aging Report that reads data from multiple sheets

I no longer need assistance with this issue

Original Query:

I am trying to create an Aging Report that takes a look at a customer sheet and a transactions sheet and reads the data and different invoices for each customer and adds the totals and looks at the terms for each customer and places them in different time buckets according to the date that is on the user form. After it reads the information and puts it in the right place and creates a new sheet as seen in the pictures, I want it to open the print preview window and have the entire aging report fit on the print preview. Not sure where to get started with this.Attachment 632683Attachment 632684Attachment 632687Attachment 632688

Please do not delete your questions, also please provide your answer - other members may have the same need.

This was your original post....

I am trying to create an Aging Report that takes a look at a customer sheet and a transactions sheet and reads the data and different invoices for each customer and adds the totals and looks at the terms for each customer and places them in different time buckets according to the date that is on the user form. After it reads the information and puts it in the right place and creates a new sheet as seen in the pictures, I want it to open the print preview window and have the entire aging report fit on the print preview. Not sure where to get started with this.

You also attached some files?