When forecasting financial models in excel, how do you make the timing of cashflows dynamic?

I am building a financial model for my company right now. We are a medical device company, so regulatory approvals timing has the ability to dramatically effect when cashflows are expected to occur. I want to add an assumptions tab, where I will include "Months until reg approval." Based on this number, I want the cashflows to be offset to the right (or left) in a different sheet by the number of months in the assumption "Months until reg approval." Which functions should I use and/or what are the best practices for doing this? Any help would be greatly appreciated!