how do you delete cells and shift the rest of the cells over?

sample.xlsx

So the file attached contains a sample of thousands of rows of data I have. Starting in column F you see social networking sites. I have copied the same data to several worksheets each labeled by a different social network. What I would like is for Sheet 1 to only display the Twitter sites. Sheet 2, which has the same raw data, to only display facebook sites, and so on. So if data is deleted, I would like the other data to move to the left to fill the black cells.

What is the best way to do this? I could use a filter for each column but then I would be left with holes everywhere