Fetching/Importing/Formatting of Stock data using Excel 2016 macro enabled spreadsheet -- 2

Need two tasks written using Excel 2016 Macro language. See also text boxes in attached spreadsheet. Use Yahoo Finance for data source. Make macros brief & easy to follow. 1) Worksheet 1. Fetch stock data for a list of tickers given a specific date (mm/dd/yyyy), cell J4. Arrange data by columns: A=original ticker, B=Open, C=High, D=Low, E=Close, F=Volume. If tickers are added or deleted, the macro still works. 2) Worksheet 2. Fetch stock data given ticker, start date, and end date (mm/dd/yyyy), cells H4, H5, and H6. Arrange: Column A=Date, B=Open, C=High, D=Low, E=Close, F=Volume.