Attempting Macro to hide current tabs and create new ones with same info (Diff tab name)

I have done about a years worth of data
I want to make a copy of each tab for the month then hide the previous months tab
Also if possible tie in the info from another document separated by tab and import by date
attached are quick samples