Macro to separate out raw data

[jph89]

Very difficult but any help or direction would be GREATLY appreciated. Here is what I am trying to accomplish:

I am trying to write a macro that will separate out the 'Data' tab in the attached document. It will look in Column 'D' from the 'Data' tab and match the name with the worksheet.

1.) Column A from the data tab would go into the 'submitted date' field for the different tabs
2.) Column J would go in the 'client name' column
3.) Column L would go in the 'carrier' column
4.) Column M would go into the 'monthly premium' column
5.) Column Z would go into the 'status' column
6.) Lastly, Column C in the data tab would have to read 'Medicare Supplement'. If it read something else, it would not go into the 'Medicare Supplement' section of each worksheet. It would just stay where it is.

In summary, if the 'Data' tab had a row that read 'Spencer Dean' in column D, the policy information for that row would populate into the 'Spencer Dean' worksheet in b6:f55.

If this is way too complicated or not possible, please let me know. Thank you to anyone whom reads this, whether you can offer any direction or not.