Split a workbook into multiple workbooks

Hi! I'd like to ask for help with this:

I need to split a workbook into different workbooks.

1. Splitting will be based on SheetA!Column E, that is ABB-C7-D1 will have its own workbook, ABBBB-C11 will have another and so on. The values in Column E will also be the filename for its corresponding workbook. I admit several codes to execute this are already available but I couldn't make it applicable (largely because of my VBA ignorance) with my file.
2. SheetA contains data validation list which depend on SheetB (which by the way, I intend to hide). So, for all the formula in SheetA to work, SheetB must be copied in every file simultaneosly with the splitting process.
3. I hope security settings and the current format (e.g. width of the columns) of the primary file could also be same across all the resulting files.

Thank you for taking time to read my post!