Dragging Down Formula From Another Tab & Skipping Rows

Hello! I'm having trouble with a formula I was hoping someone could help with. I created a Turnover Report with monthly data & a Summary page. On the tab called Plant Turnover (That holds all monthly data for the year) I am trying to create a formula to populate in the tab called Current Month Summary Page. When pulling this data I need to skip rows from the Plant Turnover tab. So, for example from the Plant Turnover tab I need to transfer C8, C21, C 34, C47 (Every 13 rows to C246) but I need to put these into rows S4, S5, S6, S7, etc. on the Current Month tab. Currently I've been manually updating these each month (Switching data in S4 to C9, S5, to C22, etc.) because the drag down formula is not pulling the proper data (not skipping rows) from the Plant Turnover tab. I wanted to create a formula I could drag down so I don't have to manually update these down to the next row every month. Is there a way to do this?

Moderator's Note: cross-posted at https://www.mrexcel.com/board/thread...-rows.1169687/

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Because it is your first post I have added the link for you. Please read the rules.