Calculate the Date of an Item Based on the Date of a Similar Item in the Previous Month

As your sheet contains nor data nor some examples of expected results ( manual) it's not really easy to help
As a rule of thumb you will need to wrap the "sheet name" with the INDIRECT function
Your formula is also a bit weird