Logistics Excel Based Application

Hi.

I am currently working on an excel based application for my work and I have encountered problems in the build. I have attached the file. The idea is that all data is input on the INPUT DATA sheet. I have the code to split the data up depending on what field it is in but I now need to to write it so when data is added it A) Doesn't copy the ENTER DATA Macro from the INPUT DATA sheet. B) Automatically Updates every sheet when data is entered on the INPUT DATA sheet C) Doesn't hide previous data on the main sheet after entering new data and D) I need to generate a macro that will generate a report for a selected week number and link it with a word document so it can be updated every week or every day automatically.

AttachmentSize
Logistics & Materials forms VBA Build.xlsm46 KB