Stock Sheet. Use Closing Balance as Opening Balance on Next monthly stock sheet

I need assistance with taking my current month stock sheet.

I have various columns which include opening stock and then I subtract or add stock and end with a column for closing balance.

I would then like to import the columns to a new workbook in the same document. Then that Closing balance column needs to populate the new month's opening balance stock column.