Pulling Data to separate sheets based on one column

In the workbook that I uploaded, row 2 has the same formula on worksheets 2,3,4. All one has to do is to copy the formula on Sheet2 row 2 to any new worksheet. The formula is linked to A1 of the active sheet.

If you select A1 on say Sheet2, click on the Data Tab, Data Validation, List and enter the "L" values in a straight list like this L1, L2, L4. Add to this listing as required. A drop-down list will appear and you can choose what value you want and the listing on the worksheet will change accordingly.