Any help here would be very much appreciated.
The attached spreadsheet is a simplified version of a much larger one, but the same prinicple will apply here. The user should first access the companies tab and in cell C3 and should select the company from the drop down- the table will then populate accordingly. After that is complete, the user will move to the Completeform tab, and the user should be able to enter Yes or No in cell K3. When the user enters Yes, I want the cells D7:D9 to populate with the data from cells C3:C5 from the Companies tab. If the user enters No in cell K3 of the completeform tab, the data will not pull from the other spreadsheet - the user will just have the capability of manually completing cells d7:d9.

Thanks,
verification spreadsheet.xlsx