将工作表中的数据拆分为同一工作簿中的更多工作表

exporting data from a CAD software I obtain a single workbook and the first sheet contains the list of the components we need to buy. The components are listed in groups and I need to split each group into more sheets. One sheet for each group. At the beginning of each group there is a merged cell containing the group name (that could be different at any exportation) and two rows below a common row:exporting data from a CAD software I obtain a s