i'm not exactly sure the vba part but you probably can record it... you can
group sheets together (ctrl + each tab) that you want .. then you should be
able to move/copy them as a group to a new workbook..

i'll try later if you want or you can try it yourself...