You are trying (in your thought process) to push the data out to the other sheets. That is not possible. You need to pull the data and manipulate it.

You need to have the date in A2 in your first sheet. On the subsequent sheets you use the formula
Sheet 2: =EOMONTH(Sheet1!A2;0)+1
Sheet 3: =EOMONTH(Sheet2!A2;0)+1
etc.

Or alternatively

Sheet 2: =EOMONTH(Sheet1!A2;0)+1
Sheet 3: =EOMONTH(Sheet1!A2;1)+1
etc.

Then you change the format (right-click on each cell and choose properties) to "custom" and enter mmmm as the format.

/Møller