VBA Macro to Create Workbooks that Include Specific rows and columns from another Tab

I believe I need it saved as a Macro, but I'm not certain. I want the new workbooks to be saved as .xls or .xlsx. Sorry I'm a bit of a VBA newb.