Need Help Sorting Data

Question

Hello,

I have a running list of data for sales. It looks like this:

I'm hoping to have it automatically populate a 2nd sheet to put each sale item row-by-row while repeating other invoice details like order #, month, etc. This would look as so:

Is there a formula to automatically do this as I enter sales data on the original list? Need to have it listed line by line for graphing and compiling data after the fact. Some orders will only have 1 item, while others can have up to 3.

Thank you so much for the help.