Hello Jason,

The answer to both questions is yes. To provide you with a solution is going to require more details about the workbook layout.

Since this is your first time here, I am not sure you can post pictures of the worksheets. You may want to upload some sample data and examples of what you want to a public file sharing service. Be sure to post back with the link.