We are working on a spreadsheet that needs to have information pulled from various other spreadsheets. We need just some of the information from the sheets (Name, part number, quantity, date) but it needs to be organized in a specific way. There will also be customers who order the same part number in different quantities and months and we would need it organized like the example excel sheet that I have attached. I am looking for a way to accomplish with a script or VBA of some sort since there will be confidential information that I cannot give out. I need to be able to just point to the correct columns and it should move the information over by itself and organize it like the example. Price is negotiable depending on how accurate of a job is done.