I am attempting to create a cash flow analysis worksheet for a manufacturing project. Sheet 1 allows the user to enter project information, including payments due and payment terms. Dates are entered for each item as well. Sheet 2 calculates the interest accural on outstanding payments.

On Sheet 3 I have entered the months of a year in individual columns across a single row. Below each listed month, I want the appropriate cash flow information that occured in the corresponding month to appear from Sheets 1 and 2. There will not be a standard number of cash flows each month; i.e. January may have 3 cash flows and August may have none. How do I do this? Any help would be greatly appreciated!