I think that realistically there's no way of using Excel to fully automate this: But, Excel can be used to simplify things for you if you put the 10 names in rows, then put "E" and "L" in columns against them when they're doing early or late shifts. You should only need columns for 10 weeks (or days, depending on how long they stay on one shift) before you start repeating the pattern. Then copy and paste the pattern as many times as you want to create a future plan. Then insert dates above the columns.
But holidays, sickness, etc. will still have to be dealt with manually.