But your post #7 description does not covered the Conditional Formatting Part

What I suggest is instead of moving the data here and there... just keep a master data and you can easily extract the required output by way of using PIVOT TABLE and project it in whatever way you want